| 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: | Whole Thread | Raw Message | 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 |