adding primary keys
adding primary keys
От:
jpoley@poley.net (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?
Re: adding primary keys
От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:
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.