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.



FAQ