"Alexei Barantsev" <barancev(at)kazbek(dot)ispras(dot)ru> 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