On Fri, Oct 08, 2010 at 11:46:31AM +0000, Johannes Meidert wrote:
> 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?
Could you give details of exactly what pg_dump commands you used? By default
pg_dump dumps tables and data without any constraints first, and then adds
constraints in a valid order. If, however, you do something like dump the
schema first, and then dump data into that schema, there's little pg_dump can
do to avoid problems such as you describe.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com