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

Re: unique index problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Costin Grigoras <costing(at)cs(dot)pub(dot)ro>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: unique index problems
Date: 2004-01-19 06:18:02
Message-ID: 21262.1074493082@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Costin Grigoras <costing(at)cs(dot)pub(dot)ro> writes:
> how could duplicate records appear when the unique index existed ?

Good question.  I have a sneaking suspicion that your trigger might be a
contributing factor, but I'm not sure how.  Can you provide a
self-contained test sequence to reproduce the problem?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-01-20 15:22:30
Subject: BUG #1055: no keys in inherited table with primary key when inserting into inheriting table
Previous:From: Tom LaneDate: 2004-01-19 05:57:23
Subject: Re: Problem with initdb

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