Обсуждение: deferrable update expected soon ?

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