The following bug has been logged online:
Bug reference: 5698
Logged by: Johannes Meidert
Email address: johannes(dot)meider(at)rohde-schwarz(dot)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?