On Thu, 23 Sep 2004, PostgreSQL Bugs List wrote: > /* ======== */ > --case 1 prepare > delete from buggy_uq; > insert into buggy_uq values (1); > insert into buggy_uq values (2); > --case 1 test > update buggy_uq set i = i + 1; > select * from buggy_uq; > --expect - SUCCESS > --result - ERROR: duplicate key violates unique constraint "buggy_uq_i_key"
This is a known issue with the unique constraint. > --case 2 prepare > --case 3 prepare I seem to get foreign key violations on both of these on both 7.4.x and 8.0 cvs using the scripts you provided just by running them in psql. I think you need to give more details about what you were trying. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
