Re: UPDATE bug in PostgreSQL-7.1.3

"Alexei Barantsev" <barancev@kazbek.ispras.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