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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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