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 wo
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?
---