Re: BUG #3724: Duplicate values added to table despite unique index

"Mason Hale" <masonhale@gmail.com> writes:
> On Nov 6, 2007 1:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Mph.  I'm afraid the evidence is mostly gone then, and we probably won't
>> be able to figure out what happened.

> Sorry about that. But I had to get things back up and running.

Understood, but it's unlikely we'll be able to find the cause without
a test case to poke at.

>> 2. Can you check that there are still 1 (rather than 0) copies of the
>> rows in the 8.2.5 DB?

> Yes, we have 1 of each row (I kept the most recently updated version of
> each):

Ah, I forgot that the rows were obviously not identical because of the
differing updated_at values.

Tell us more about the updating process --- is it likely that there
could be conflicting concurrent updates on a row?  What does your
app do in such cases?

            regards, tom lane