Re: oids and pg_class_oid_index constraint violations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: oids and pg_class_oid_index constraint violations
Дата
Msg-id 3785.1123101209@sss.pgh.pa.us
обсуждение исходный текст
Ответ на oids and pg_class_oid_index constraint violations  ("Aaron Harsh" <ajh@rentrak.com>)
Список pgsql-general
"Aaron Harsh" <ajh@rentrak.com> writes:
> We've just recently started seeing sporadic constraint violations on system tables.  For example:
>   duplicate key violates unique constraint "pg_class_oid_index" [for Statement "CREATE TEMPORARY TABLE...

OID wraparound would explain that ...

> and the occasional
>   unexpected chunk number 0 (expected 1) for toast value

... but not that.  The latter might possibly be due to a corrupt index
on a toast table.  If you have a reproducible way of causing it, I'd
definitely love to see it.

            regards, tom lane

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Windows file path for copy
Следующее
От: "Aaron Harsh"
Дата:
Сообщение: Re: oids and pg_class_oid_index constraint