Batch Table Creation - Foreign Key Problem - Mailing list pgsql-novice

From Daniel Whelan
Subject Batch Table Creation - Foreign Key Problem
Date
Msg-id 3DFE447D.4080906@ophelan.com
Whole thread Raw
Responses Re: Batch Table Creation - Foreign Key Problem
List pgsql-novice
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!

Daniel


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with pg_dump
Next
From: Josh Berkus
Date:
Subject: Re: Redhat Database ???