"Alexei Barantsev" <[EMAIL PROTECTED]> writes: > UPDATE buggy SET field1 = field1+1; > psql:/home/barancev/tmp/pg_bug.sql:17: ERROR: Cannot insert a duplicate key > into unique index buggy_field1_key
Unfortunately, that's never worked, as our unique constraints are tested immediately not at end of statement. 7.0 is certainly no better about it than 7.1... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster