adding primary keys - Mailing list pgsql-admin

From jpoley@poley.net (jason)
Subject adding primary keys
Date
Msg-id ad2db287.0112031139.1375664a@posting.google.com
Whole thread Raw
Responses Re: adding primary keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
how come you can not alter a table and add a primary key after the
table has been created?
(or at least i can't seem to)


mydb=> alter table actions add primary key (action);
ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that
constraint type.


any suggestions?

pgsql-admin by date:

Previous
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: psql option for writing schema
Next
From: "Ligia Pimentel"
Date:
Subject: Making user names NOT case sensitive