Hello, On Fri, 8 Feb 2002 11:32:50 -0800 (PST), Stephan Szabo wrote:
> >On Fri, 8 Feb 2002 [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
