John Havard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is.
Short Description update not atomic Long Description Version tested: 7.2b1, all 7.1 Update is not atomic. This really is not a problem, unless updating a field with a unique index. Sample Code jhavard=# CREATE TABLE blah (num int unique); NOTICE: CREATE TABLE/UNIQUE will create implicit index 'blah_num_key' for table 'blah' CREATE jhavard=# INSERT INTO blah VALUES (1); INSERT 278477 1 jhavard=# INSERT INTO blah VALUES (2); INSERT 278478 1 jhavard=# INSERT INTO blah VALUES (3); INSERT 278479 1 jhavard=# INSERT INTO blah VALUES (4); INSERT 278480 1 jhavard=# INSERT INTO blah VALUES (5); INSERT 278481 1 jhavard=# UPDATE blah set num = num+2; ERROR: Cannot insert a duplicate key into unique index blah_num_key No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
