designating a column as primary key after creation

Поиск
Список
Период
Сортировка
Искать
От
Fran Fabrizio
Тема
designating a column as primary key after creation
Дата
Msg-id
3.0.5.32.19980812215755.00825760@mail.primary.net
Список
Дерево обсуждения
designating a column as primary key after creation Fran Fabrizio <fran@primary.net>
Re: [GENERAL] designating a column as primary key after creation Aleksey Dashevsky <postgres@luckynet.co.il>
Nulls (was Re: designating a column as primary key after creation) Herouth Maoz <herouth@oumail.openu.ac.il>

Why does postgres choke on the following:

alter table mytable add constraint mycolumn_pk primary key(mycolumn);

is this possible in a postgres database?  if not, what's an easy
workaround, i really need to have this column as primary key. 

Thanks!

-Fran

В списке pgsql-general по дате отправления
От: Jeremiah Davis
Дата:
От: Dirk Elmendorf
Дата:
Сообщение: LibPQ Notice
FAQ