Обсуждение: adding primary keys

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?

On 3 Dec 2001, jason wrote:

> how come you can not alter a table and add a primary key after the
> table has been created?

Because it wasn't implemented for that constraint type ;) (I
think it'll work in at least some cases for 7.2)?

> any suggestions?

Check the archives for 7.1 and earlier workarounds, it's come
up fairly recently.