X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5FCC6475A9E for ; Tue, 11 Feb 2003 12:41:52 -0500 (EST) Received: from ms-smtp-03.tampabay.rr.com (ms-smtp-03.tampabay.rr.com [65.32.1.41]) by postgresql.org (Postfix) with ESMTP id C2460475A97 for ; Tue, 11 Feb 2003 12:41:51 -0500 (EST) Received: from mattspc (169-52.34-65.tampabay.rr.com [65.34.52.169]) by ms-smtp-03.tampabay.rr.com (8.12.5/8.12.5) with ESMTP id h1BHftrU023830; Tue, 11 Feb 2003 12:41:55 -0500 (EST) From: "Matthew Nuzum" To: "'Johannes Lochmann'" , Subject: Re: constrains questios .. Date: Tue, 11 Feb 2003 12:41:46 -0500 Organization: Bearfruit.org Message-ID: <004e01c2d1f4$d9546f50$6900a8c0@mattspc> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal In-Reply-To: <200302111748.24760.johannes.lochmann@chello.at> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/221 X-Sequence-Number: 11619 > > is better to create constrains while creating table or after the table > > is created? I'm working on sql script which should create about 40 > tables. > > I usually first create the tables, then the constraints. Rational: You can > create the tables in any sequence you want to. > > HTH > > Johannes Lochmann > Can you please demonstrate the syntax you would use to create the constraints? I'm not real clear on this and my attempts haven't produced what I wanted. -- Matthew Nuzum www.bearfruit.org cobalt@bearfruit.org