Received: from chiru.svana.org (svana.org [210.9.56.23]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1L41Hx12770; Tue, 20 Feb 2001 23:01:17 -0500 (EST) (envelope-from kleptog@svana.org) Received: from kleptog by chiru.svana.org with local (Exim 3.12 #1 (Debian)) id 14VQSU-00089b-00; Wed, 21 Feb 2001 15:00:54 +1100 Date: Wed, 21 Feb 2001 15:00:54 +1100 To: Chris Czeyka Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: two tables - foreign keys referring to each other... Message-ID: <20010221150054.B31213@chiru.svana.org> References: <3A93366B.DC0B83F4@skwea.co.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A93366B.DC0B83F4@skwea.co.jp>; from czeyka@skwea.co.jp on Wed, Feb 21, 2001 at 12:30:51PM +0900 From: Martijn van Oosterhout X-Archive-Number: 200102/1044 X-Sequence-Number: 4963 On Wed, Feb 21, 2001 at 12:30:51PM +0900, Chris Czeyka wrote: [big snip] > of course I get the ERROR, that admin_t doesn't exist. So? help the stupid! > pls! I think the general idea is to create the tables first without the constraints and then do ALTER TABLE ADD CONSTRAINT afterwards. HTH, Martijn