Postgres Pro
Downloads
Home   >   mailing lists

defferable update & unique - Mailing list pgsql-general

From Ben-Nes Michael
Subject defferable update & unique
Date
Msg-id 00e701c3ae8e$5b8ef370$0500a8c0@canaan.co.il
Whole thread Raw
Responses Re: defferable update & unique  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: defferable update & unique  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: defferable update & unique  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tree view 
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;

cheers
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------

pgsql-general by date:

Previous
From: Uros
Date:
Subject: Optimizing query
Next
From: "Matthew Lunnon"
Date:
Subject: Re: Optimizing query