deferrable update expected soon ?

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: deferrable update expected soon ?
Date: 2003-04-07 11:59:19
Message-ID: 004101c2fcfd$1f4dc0f0$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

Does any one know when postgres will support deferrable update ?

to prevent current error ?

CREATE TABLE test (
col1 INT UNIQUE );

INSERT INTO test values (1);
INSERT INTO test values (2);
INSERT INTO test values (3);

UPDATE test set col1 = col1+1;

ERROR: Cannot insert a duplicate key into unique index test_col1_key

something like:

CREATE TABLE test (
col1 INT UNIQUE DEFERRABLE );

Cheers
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://sites.canaan.co.il
--------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2003-04-07 12:19:57 possible time change issue - known problem?
Previous Message Jan Wieck 2003-04-07 11:34:47 Re: unable to dump database, toast errors