Re: defferable update & unique - Mailing list pgsql-general

From Bruce Momjian
Subject Re: defferable update & unique
Date
Msg-id 200311191639.hAJGdUY23381@candle.pha.pa.us
Whole thread Raw
In response to defferable update & unique  ("Ben-Nes Michael" <miki@canaan.co.il>)
Responses Re: defferable update & unique
List pgsql-general
Ben-Nes Michael wrote:
> Hi All
>
> Does 7.4 support defferable updates on unique column ?
>
> example
>
> unique INT colum named u_test has the following values: 1, 2, 3, 4, 5
>
> can i do update table set u_test = u_test + 1;

No, this is on our TODO list.  Also, I can't think of a workaround.  :-(

--
  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: Bruce Momjian
Date:
Subject: Re: Point-in-time data recovery - v.7.4
Next
From: Bruno Wolff III
Date:
Subject: Re: Storing a chain