Thread: deferring/disabling unique index

deferring/disabling unique index

From
Oleg Lebedev
Date:
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