Re: PG 7.4: duplicate rows in violation of unique

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PG 7.4: duplicate rows in violation of unique
Дата
Msg-id 22859.1108011047@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PG 7.4: duplicate rows in violation of unique  (Steve Lane <slane@soliantconsulting.com>)
Ответы Re: PG 7.4: duplicate rows in violation of unique  (Steve Lane <slane@soliantconsulting.com>)
Re: PG 7.4: duplicate rows in violation of unique  (Steve Lane <slane@soliantconsulting.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Steve Lane
Дата:
Сообщение: Re: PG 7.4: duplicate rows in violation of unique
Следующее
От: Steve Lane
Дата:
Сообщение: Re: PG 7.4: duplicate rows in violation of unique