i found a workaround, but relativly slow. The column is not unique and when the update is finished i fire up a trigger that check for uniqueness.
lets wait for pg7.5 :) -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4-6990098 http://www.canaan.net.il -------------------------- ----- Original Message ----- From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Ben-Nes Michael" <[EMAIL PROTECTED]> Cc: "postgresql" <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 6:39 PM Subject: Re: [GENERAL] defferable update & unique > 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 > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
