Re: droping unique constraint

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: droping unique constraint
Дата
Msg-id
Pine.LNX.4.21.0010252229010.790-100000@peter.localdomain
Ответ на
droping unique constraint (Marcin Mazurek)
Список
Дерево обсуждения
droping unique constraint Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
Re: droping unique constraint Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: droping unique constraint Peter Eisentraut <peter_e@gmx.net>
Marcin Mazurek writes:

> can anybody help me with dropping unique constrint on attribute. I was
> looking for it in pg_attributebut I think this is done in some other way.
> How can I change it without recreating whole table.

Drop the unique index on the column.  Use psql's \d command to find the
name.

> ps. list archives are unfortunately unusable...

Use www.geocrawler.com.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

В списке pgsql-admin по дате отправления
От: The Hermit Hacker
Дата:
Сообщение: Re: Archives?
От: Joel Pang
Дата:
Сообщение: disable auto-commit
FAQ