Postgres Pro
Downloads
Home   >   mailing lists

Re: Add Primary Key to a Table - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Add Primary Key to a Table
Date
Msg-id 200208021619.51272.josh@agliodbs.com
Whole thread Raw
In response to Add Primary Key to a Table  ("Tom Haddon" <tom@betterhealthfoundation.org>)
Responses Re: Add Primary Key to a Table  ("Tom Haddon" <tom@betterhealthfoundation.org>)
List pgsql-sql
Tree view 
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 BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: "Tom Haddon"
Date:
Subject: Add Primary Key to a Table
Next
From: "Tom Haddon"
Date:
Subject: Re: Add Primary Key to a Table