Thread: BUG #1102: DOMAIN definition too late in pg_dump

BUG #1102: DOMAIN definition too late in pg_dump

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1102
Logged by:          klaus daum

Email address:      kd@orderrace.com

PostgreSQL version: 7.4

Operating system:   linux 2.4

Description:        DOMAIN definition too late in pg_dump

Details:

using pg 7.4.2:

- create table t
- insert data into table t
- create domain d
- add col to table t with domain d
- pg_dump output has: definition of domain d after defintion of table t (not
readable without edit of dump)

regards,
klaus

Re: BUG #1102: DOMAIN definition too late in pg_dump

From
Tom Lane
Date:
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Description:        DOMAIN definition too late in pg_dump

pg_dump ordering is a longstanding problem.  It's fixed in CVS tip,
I believe, but the changes were too major to consider back-patching.

            regards, tom lane