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

From Bruce Momjian
Subject Re: deferring/disabling unique index
Date
Msg-id 200401091732.i09HWYT12504@candle.pha.pa.us
Whole thread Raw
In response to Re: deferring/disabling unique index  (Oleg Lebedev <oleg.lebedev@waterford.org>)
List pgsql-general
Oleg Lebedev wrote:
> 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?

Not sure.  I seem to remember a way someone got around this, but can't
remember the details.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "Erwan DUROSELLE"
Date:
Subject: Rép. : Re: start/stop a database
Next
From: "Joshua D. Drake"
Date:
Subject: Re: deferring/disabling unique index