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 993DBE5B4D02194382EC8DF8554A52731D78F8@postoffice.waterford.org
Whole thread Raw
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: Pavel Stehule
Date:
Subject: why I can call pg_stat_get_backend_idset directly
Next
From: Mike Nolan
Date:
Subject: Re: order by is ambiguous