deferring/disabling unique index

From: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: deferring/disabling unique index
Date: 2004-01-09 16:44:30
Message-ID: 993DBE5B4D02194382EC8DF8554A52731D7915@postoffice.waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to know if there is a way to defer or disable a unique index on a
table during an update. One way would be to set indisunique to false,
perform update and then set to true. But, this seems to be an ugly
solution.

I've posted a similar message 6 months ago and at that time deferring
unique constraints was on a todo list. I wonder if this has been added
to 7.4.1 release. If not, what is the best way to disable an index on a
table?

Thanks.

Oleg

*************************************

This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.

*************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-01-09 17:19:21 Re: deferring/disabling unique index
Previous Message Gerwin Philippo 2004-01-09 15:57:55 Re: Trouble with MsAccess and records above 13000