This is a discussion on Re: Major Problems with pg_dump within the pgsql Novice forums, part of the PostgreSQL category; --> =?iso-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at> writes: > Here's one example. > We have a cdr_type in line 64 > CREATE TYPE cdr_type ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| =?iso-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at> writes: > Here's one example. > We have a cdr_type in line 64 > CREATE TYPE cdr_type AS ( > ... > "Charge" charge_type, > ... > ); > while charge_type gets defined in line 86: > CREATE DOMAIN charge_type AS numeric(9,4) > CONSTRAINT "$1" CHECK ((VALUE >= (0)::numeric)); Ah --- it was missing the dependency in this case, and ordering the types by name by default. Fixed; thanks for the report! regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |