Postgres Pro
Downloads
Home   >   mailing lists

deferring/disabling unique index - Mailing list pgsql-general

From Oleg Lebedev
Subject deferring/disabling unique index
Date
Msg-id 993DBE5B4D02194382EC8DF8554A52731D7915@postoffice.waterford.org
Whole thread Raw
Responses Re: deferring/disabling unique index  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: start/stop a database
Next
From: Tom Lane
Date:
Subject: Re: array faults?