Hello,
On Fri, 8 Feb 2002 11:32:50 -0800 (PST), Stephan Szabo wrote:
>
>On Fri, 8 Feb 2002 pgsql-bugs@postgresql.org wrote:
>
>> 2. tables with complex foreign key constrains will not be imported
>
>I probably couldn't help with the other question, but...
>
>What do you mean by this? Does it error on the creation, does it
>make the tables but not the constraints?
>
Unfortunately I get creation errors on a couple of tables.
As a result the table and the data are missing in the new 7.2 DB.
I think the problem is, that the order in which the tables / constrains are
exported is not coerect.
Postgres tries to import the tables in the wrong order.
Example:
Table A depends on table B.
Unfortunately table B will be imported AFTER table A.
Result: table A will not be imported; the date from table A will not be importet.
Bye
Rainer Tammer