Re: [SQL] Add Primary Key to a Table

2002-08-02 Thread Tom Haddon
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:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 4:20 PM To: Tom Haddon; [EMAIL PROTECTED] Subject: Re: [SQL] Add Primary Key to a

Re: [SQL] Add Primary Key to a Table

2002-08-02 Thread Josh Berkus
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