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
--------------------------
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 |