Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8BAEB476410 for ; Fri, 2 Aug 2002 19:20:26 -0400 (EDT) Received: from sterling.betterhealthfoundation.net (user-112ugh2.biz.mindspring.com [66.47.66.34]) by postgresql.org (Postfix) with ESMTP id 5C649476089 for ; Fri, 2 Aug 2002 19:20:22 -0400 (EDT) Received: from dinar ([192.168.1.12]) by sterling.betterhealthfoundation.net with Microsoft SMTPSVC(5.0.2195.4905); Fri, 2 Aug 2002 16:20:23 -0700 From: "Tom Haddon" To: Cc: Subject: Re: Add Primary Key to a Table Date: Fri, 2 Aug 2002 16:20:23 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 In-Reply-To: <200208021619.51272.josh@agliodbs.com> Importance: Normal X-OriginalArrivalTime: 02 Aug 2002 23:20:23.0625 (UTC) FILETIME=[2D5CF390:01C23A7B] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/51 X-Sequence-Number: 8897 Hi Josh, I think that solves it for me - I'm using 7.1.3 - will upgrade appropriately. Thanks, Tom -----Original Message----- From: Josh Berkus [mailto:josh@agliodbs.com] Sent: Friday, August 02, 2002 4:20 PM To: Tom Haddon; pgsql-sql@postgresql.org Subject: Re: [SQL] Add Primary Key to a Table Tom, > ALTER TABLE "agency_contact_info" ADD CONSTRAINT "agency_contact_info_pkey" > PRIMARY KEY ("id"); > > I get a message saying "ALTER TABLE / ADD CONSTRAINT not implemented for > that constraint type". Is this a bug, or am I doing something wrong? What version are you using? That command is supported with Postgres 7.2, but not with earlier versions. -- -Josh Berkus Aglio Database Solutions San Francisco