Re: Add Primary Key to a Table

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Tom Haddon" <tom(at)betterhealthfoundation(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Add Primary Key to a Table
Date: 2002-08-02 23:19:51
Message-ID: 200208021619.51272.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Haddon 2002-08-02 23:20:23 Re: Add Primary Key to a Table
Previous Message Tom Haddon 2002-08-02 23:16:36 Add Primary Key to a Table