X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C9206475A7F for ; Tue, 11 Feb 2003 12:29:22 -0500 (EST) Received: from viefep16-int.chello.at (viefep16-int.chello.at [213.46.255.17]) by postgresql.org (Postfix) with ESMTP id 9D1D04759BD for ; Tue, 11 Feb 2003 12:29:21 -0500 (EST) Received: from gimli.auenland.local ([213.47.228.41]) by viefep11-int.chello.at (InterMail vM.5.01.05.17 201-253-122-126-117-20021021) with ESMTP id <20030211164330.MIQL16768.viefep11-int.chello.at@gimli.auenland.local> for ; Tue, 11 Feb 2003 17:43:30 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Johannes Lochmann To: pgsql-sql@postgresql.org Subject: Re: constrains questios .. Date: Tue, 11 Feb 2003 17:48:24 +0100 User-Agent: KMail/1.4.3 References: <3E491854.9080401@polonium.de> In-Reply-To: <3E491854.9080401@polonium.de> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200302111748.24760.johannes.lochmann@chello.at> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/220 X-Sequence-Number: 11618 On Tuesday 11 February 2003 16:35, Rafal Kedziorski wrote: Hi, > 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= =20 create the tables in any sequence you want to. HTH Johannes Lochmann --=20 Disclaimer - These opiini^H^H damn! ^H^H ^Q ^[ .. :w :q :wq :wq! ^d X^? exit X Q ^C ^c ^? :quitbye CtrlAltDel ~~q :~q logout save/quit :!QUIT ^[zz ^[ZZZZZZ ^H man vi ^@ ^L ^[c ^# ^E ^X ^I ^T ? help helpquit ^D ^d man help ^C exit ?Quit ?q CtrlShftDel "Hey, what does this button d..."