Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE bug in PostgreSQL-7.1.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: UPDATE bug in PostgreSQL-7.1.3
Date
Msg-id 8006.1005771146@sss.pgh.pa.us
Whole thread Raw
In response to UPDATE bug in PostgreSQL-7.1.3  ("Alexei Barantsev" <barancev@kazbek.ispras.ru>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Documentation nits
Next
From: Tom Lane
Date:
Subject: Re: time's running short for you to reserve 5432/tcp!!!!