I'm currently using 7.3b2 for test and development. I ran into a problem
using a dumped schema from pg_dump. After importing the dumped schema,
any delete or update involving a foreign key results in a relation 0
does not exist error. I noticed that all my foreign key declarations
were moved from the table create to separate statements at the bottom of
the dump file. Thanks in advance for any insight into this problem you
can lend.

-John



15 Oct 2002 14:53:46 -0400
John Halderman <john@paymentalliance.net>
foreign key problem with pg_dump under 7.3b2
On 15 Oct 2002, John Halderman wrote:

> I'm currently using 7.3b2 for test and development. I ran into a problem
> using a dumped schema from pg_dump. After importing the dumped schema,
> any delete or update involving a foreign key results in a relation 0
> does not exist error. I noticed that all my foreign key declarations
> were moved from the table create to separate statements at the bottom of
> the dump file. Thanks in advance for any insight into this problem you
> can lend.

If the data has moved from earlier versions (I think 7.0.x) there was a
bug in an older pg_dump that dropped a piece of information (the
related table) and the loss would be carried along.  That
information is now used rather than the name passed in the args
so said dumps break on b2. Current sources should fill in the missing
information whenever possible.


Tue, 15 Oct 2002 12:12:48 -0700 (PDT)
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: foreign key problem with pg_dump under 7.3b2