I'm trying to create a set of tables, some of which have a foreign key
pointing to other tables in the same set. The problem arises when it
tries to add a table before the table it depends on has been created. Is
there any way to defer the checking of foreign key dependancies until
after the whole transaction block?
Alternately, would I be better off creating the tables with no foreign
keys, and issuing alter statements at the end to add the keys? Thanks!
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2002-12-16 21:28:37|
|Subject: Re: Redhat Database ???|
|Previous:||From: Tom Lane||Date: 2002-12-16 21:19:22|
|Subject: Re: Problems with pg_dump |