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