alter table ad primary key
От
Christoph Dalitz
Тема
alter table ad primary key
Дата
Msg-id
20020823170804.242b85de.christoph.dalitz@hs-niederrhein.de
Список
Дерево обсуждения
Re: alter table ad primary key Dmitry Tkach <dmitry@openratings.com>
Hello,
trying "alter table buecher add primary key (isbn);"
gives the error "ALTER TABLE / ADD CONSTRAINT is not implemented"
with PG 7.1.
Does anybody know whether this works with a newer PG version?
Did someone already implement a workaround in form of a stored
procedure that does the following:
- copy the table entirely to a temporary table
- remember all indices, constraints, rules and triggers on the old table
(is that possible at all?)
- drop the old table
- recreate the table with a primary key
- copy the temp table bakc
- drop the temp table
?
Thanks,
Christoph Dalitz
В списке pgsql-general по дате отправления