Re: BUG #2379: Duplicate pkeys in table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2379: Duplicate pkeys in table
Date
Msg-id 24629.1144336170@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2379: Duplicate pkeys in table  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: BUG #2379: Duplicate pkeys in table  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-bugs
Philip Warner <pjw@rhyme.com.au> writes:
> Tom Lane wrote:
>> The thing that is striking though is
>> that the xmin/cmin values are all the same, indicating that all six
>> tuples were inserted by the same command.  That seems pretty odd.  Can
>> you show us the procedure by which rows are inserted in this table?
>>
> The original insertion is probably not relevant (it happened months
> ago); there are many places that update the table.

OK, what I should say is that all these tuples were updated by the same
command.

> Updates happen regularly from many sources, but the procedure that does
> the most updates is a trigger. Do you want to see  that?

Please.

Also, if you care to run pg_filedump -i -F over the table, it'd be
interesting to see the complete header info for each of these tuples.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Philip Warner
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table
Next
From: Philip Warner
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table