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 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
