Re: Updating a unique constrant

From: Peter of the Norse <rahmcoff(at)radio1190(dot)org>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Updating a unique constrant
Date: 2004-06-07 19:31:01
Message-ID: Pine.LNX.4.44.0406071329040.19430-100000@Radio1190.Colorado.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 6 Jun 2004, Bruno Wolff III wrote:

> Uniqueness constraints can't be deferred. One common strategy is to change
> all of the values to values in a set disjoint from what they are now union
> with what they will be. (Commonly people make the negative of their
> current value.) And then change them to the correct new values.

Thanks for the advice. I already screwed up my test database when tring to
make it work without the unique index.
--
Peter of the Norse

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-06-07 19:58:19 Re: [GENERAL] bug in 7.4.2, concern unicode and russian content of
Previous Message Jeff Davis 2004-06-07 18:33:58 Re: [HACKERS] Slony-I goes BETA (possible bug)