Re: missing chunk number 0 for toast value ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: missing chunk number 0 for toast value ...
Дата
Msg-id 25742.1146688817@sss.pgh.pa.us
обсуждение исходный текст
Ответ на missing chunk number 0 for toast value ...  (MIlos Prudek <prudek@bvx.cz>)
Ответы Re: missing chunk number 0 for toast value ...  (MIlos Prudek <prudek@bvx.cz>)
Список pgsql-admin
MIlos Prudek <prudek@bvx.cz> writes:
> select * from info;
> ERROR:  missing chunk number 0 for toast value 190937

I was going to suggest the REINDEX, but no luck :-(

> What should I do to salvage the table?

Find the row containing the busted toast reference, and delete that row
(or just UPDATE it with some new value for the toasted column).  You can
home in on it with the usual sorts of search methods --- look in the PG
list archives for previous discussions of locating corrupted rows.

            regards, tom lane

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

Предыдущее
От: MIlos Prudek
Дата:
Сообщение: missing chunk number 0 for toast value ...
Следующее
От: "[S] Dhandapani"
Дата:
Сообщение: Help on restoration