Re: PG 7.4: duplicate rows in violation of unique

Steve Lane <slane@soliantconsulting.com> writes:
> Sorry -- 7.4.5

I'm wondering if this could be related to this post-7.4.5 fix:

2004-10-13 18:22  tgl

    * contrib/pgstattuple/pgstattuple.c,
    src/backend/access/heap/heapam.c,
    src/backend/utils/adt/ri_triggers.c (REL7_4_STABLE): Repair
    possible failure to update hint bits back to disk, per
    http://archives.postgresql.org/pgsql-hackers/2004-10/msg00464.php.

What you are describing sure sounds like a foulup in commit status
marking for multiple versions of a row.  I'm not convinced it would be
fixed by the abovementioned patch, but it sounds close.

            regards, tom lane