The following bug has been logged online: Bug reference: 5698 Logged by: Johannes Meidert Email address: johannes.mei...@rohde-schwarz.com PostgreSQL version: 8.3.11, 9.0.1 Operating system: Windows Description: pg_dump (8.3.11) does not consider constrains Details:
pg_dump dumps tables in the worng order for constraints (table a refrences key of table b, but table a is dumped first). As a consequence an import fails, because the required foreign key (in table b) is missing when table a is imported. Work around: import twice. Is this fixed in version 9.0? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs