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-08 18:20:27
Message-ID: 993DBE5B4D02194382EC8DF8554A52731D78F8@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.

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

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-01-08 19:36:56 Re: order by is ambiguous
Previous Message Pavel Stehule 2004-01-08 17:37:28 why I can call pg_stat_get_backend_idset directly