alter table ad primary key

Поиск
Список
Период
Сортировка
От Christoph Dalitz
Тема alter table ad primary key
Дата
Msg-id 20020823170804.242b85de.christoph.dalitz@hs-niederrhein.de
обсуждение исходный текст
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: trigger fired on changes in specific column
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to retrieve a comment/description from a table