designating a column as primary key after creation - Mailing list pgsql-general

From Fran Fabrizio
Subject designating a column as primary key after creation
Date
Msg-id 3.0.5.32.19980812215755.00825760@mail.primary.net
Whole thread Raw
Responses Re: [GENERAL] designating a column as primary key after creation  (Aleksey Dashevsky <postgres@luckynet.co.il>)
List 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


pgsql-general by date:

Previous
From: Jeremiah Davis
Date:
Subject: Re: [GENERAL] Select MIN() & MAX()
Next
From: Dirk Elmendorf
Date:
Subject: LibPQ Notice