Re: [ADMIN] adding primary keys

2001-12-06 Thread Stephan Szabo
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

[ADMIN] adding primary keys

2001-12-06 Thread jason
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? ---