X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 966E7D1B502 for ; Tue, 16 Sep 2003 13:45:39 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 05963-05 for ; Tue, 16 Sep 2003 10:45:12 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id C66D5D1B4EB for ; Tue, 16 Sep 2003 10:45:07 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h8GDfvMc010406; Tue, 16 Sep 2003 07:41:57 -0600 (MDT) Date: Tue, 16 Sep 2003 07:38:33 -0600 (MDT) From: "scott.marlowe" To: Rod Taylor Cc: "S.P.Vimala" , Subject: Re: In-Reply-To: <1063718501.24775.0.camel@jester> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/56 X-Sequence-Number: 2333 On Tue, 16 Sep 2003, Rod Taylor wrote: > > I'm not sure how to add constraints to already existing tables, so you > > might wanna do this in a test table, move your data over, then rename > > tables to swap in the new table. > > ALTER TABLE ... ADD CONSTRAINT For some unknown reason, that part of the alter table under \h eluded me when I was doing this... Well, it WAS like 6am, and I hadn't had any coffee. Think I'll take a nap under my desk now. :-)