Re: deferring/disabling unique index - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: deferring/disabling unique index
Date
Msg-id 3FFEE6AD.8030506@commandprompt.com
Whole thread Raw
In response to Re: deferring/disabling unique index  (Oleg Lebedev <oleg.lebedev@waterford.org>)
Responses Re: deferring/disabling unique index
List pgsql-general
>So, does it mean that the only way to disable the index is to drop and
>recreate it? What about setting indisunique to false temporarily?
>
>
>
I am just curious... why would you want to defer a unique constraint?

Sincerely,

Joshua Drake






--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: deferring/disabling unique index
Next
From: Chris Gamache
Date:
Subject: TSearch2 ... ignore word repetition for rank