Received: from relay.mail.insnet.cw.net (relay.mail.insnet.cw.net [213.38.238.97]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f788kS605333 for ; Wed, 8 Aug 2001 04:46:28 -0400 (EDT) (envelope-from gary.stainburn@ringways.co.uk) Received: from stan.ringways.co.uk ([213.38.87.130]) by relay.mail.insnet.cw.net (8.11.2/8.11.2) with ESMTP id f788k4k29750; Wed, 8 Aug 2001 09:46:04 +0100 (BST) Received: from gary.ringways.co.uk ([10.1.1.2]) by stan.ringways.co.uk with smtp (Exim 3.13 #1) id 15UOkt-0006OG-00; Wed, 08 Aug 2001 09:31:56 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Gary Stainburn Organization: Ringways Garages Ltd To: Tom Lane , Jan Wieck Subject: Re: Are circular REFERENCES possible ? Date: Wed, 8 Aug 2001 09:43:28 +0100 X-Mailer: KMail [version 1.2] Cc: Josh Berkus , Denis Bucher , pgsql-sql@postgresql.org References: <200108071654.f77GssQ01998@jupiter.us.greatbridge.com> <8929.997209304@sss.pgh.pa.us> In-Reply-To: <8929.997209304@sss.pgh.pa.us> MIME-Version: 1.0 Message-Id: <01080809432802.23554@gary.ringways.co.uk> Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/116 X-Sequence-Number: 4337 Hi all, On Tuesday 07 August 2001 7:35 pm, Tom Lane wrote: > Jan Wieck writes: > > The point is that we based our implementation of foreign keys > > on the SQL3 specs. DEFERRED is not in SQL-92 AFAIK. > > I still have a concern about this --- sure, you can set up the circular > references using ALTER TABLE, but will pg_dump dump them correctly? Based on a small example I've done, I'd say yes. This is because pg_dump doesn't specify the contraints when it creates the tables, it does it at the end by using 'CREATE CONSTRAINT' commands. I have a relationship Members -> teams -> regions -> members and it dumped and restored fine. Gary > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000