Re: Disable unique constraint in Postgres

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Disable unique constraint in Postgres
Дата
Msg-id 41b12ce3422cf41b050bcb359e45cc453d753c8e.camel@cybertec.at
обсуждение исходный текст
Ответ на Disable unique constraint in Postgres  (Nikhil Ingale <niks.bgm@gmail.com>)
Ответы Re: Disable unique constraint in Postgres  (Norbert Poellmann <np@ibu.de>)
Список pgsql-admin
Дерево обсуждения 
On Fri, 2022-11-25 at 12:48 +0530, Nikhil Ingale wrote:
> We have an alter command to disable any constraints in the oracle db. Similarly do we have any
> command to disable the UNIQUE constraint in postgres. Most of the postgres db forum suggests
> dropping the UNIQUE constraint. But, I don't want to drop the constraint here instead just
> disable the unique constraint.
> 
> Need your inputs on the same.

The db forums were right: you cannot disable a unique constraint in PostgreSQL.

Yours,
Laurenz Albe

В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Difference between host, hostssl and hostnossl connection type
Следующее
От: Dhirendra Singh
Дата:
Сообщение: Re: Difference between host, hostssl and hostnossl connection type