"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

Reply via email to