designating a column as primary key after creation

From: Fran Fabrizio <fran(at)primary(dot)net>
To: pgsql-general(at)hub(dot)org
Subject: designating a column as primary key after creation
Date: 1998-08-13 02:57:55
Message-ID: 3.0.5.32.19980812215755.00825760@mail.primary.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Why does postgres choke on the following:

alter table mytable add constraint mycolumn_pk primary key(mycolumn);

is this possible in a postgres database? if not, what's an easy
workaround, i really need to have this column as primary key.

Thanks!

-Fran

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dirk Elmendorf 1998-08-13 03:41:17 LibPQ Notice
Previous Message Jeremiah Davis 1998-08-12 23:50:27 Re: [GENERAL] Select MIN() & MAX()