Skip site navigation (1) Skip section navigation (2)

Re: BUG #1266: Improper unique constraint / MVCC activities

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Aleksey Fedorchenko <alexey_f(at)ukr(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1266: Improper unique constraint / MVCC activities
Date: 2004-09-23 14:15:45
Message-ID: 20040923071258.J94877@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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.



In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-09-23 14:45:21
Subject: Re: BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID
Previous:From: PostgreSQL Bugs ListDate: 2004-09-23 12:09:02
Subject: BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group