Re: unable to dump database, toast errors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: unable to dump database, toast errors
Дата
Msg-id 12865.1049401482@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: unable to dump database, toast errors  (Lonni J Friedman <lfriedman@vasoftware.com>)
Ответы Re: unable to dump database, toast errors
Список pgsql-general
Lonni J Friedman <lfriedman@vasoftware.com> writes:
> Do you mean the fields/rows in pg_toast_302323 or artifact_file ?

The ones in artifact_file.

> How
> would i determine which ones reference broken toast entries?

If you get the toast error when you try to read the field's value, then
it's broken ...

You may find yourself doing things like "select * from artifact_file
limit N" to try to narrow down which rows contain broken values.  If so,
keep in mind that (in 7.2) LIMIT will read one more row than it returns;
so if you can select N rows but not N+1 rows, the problem is actually in
row N+2.

            regards, tom lane


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

Предыдущее
От: Marc Drouin
Дата:
Сообщение: Re: Newbie: problem Connecting to Server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql password when FreeBSD boots -- what's usual?