Disable unique constraint in Postgres

From: Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Disable unique constraint in Postgres
Date: 2022-11-25 07:18:33
Message-ID: CALXkTpyQXcT5m7cYttWjLv3n8xGC+MFYVah-q9Lxz-8FKBoMmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
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.

Regards,
Nikhil Ingale

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dhirendra Singh 2022-11-25 07:27:29 Re: Difference between host, hostssl and hostnossl connection type
Previous Message Laurenz Albe 2022-11-25 07:09:52 Re: Difference between host, hostssl and hostnossl connection type