Re: ERROR: catalog is missing 9 attribute(s) for relid 10297

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: catalog is missing 9 attribute(s) for relid 10297
Дата
Msg-id 16843.1199462347@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: catalog is missing 9 attribute(s) for relid 10297  ("O'Shea, Brendan" <boshea@akamai.com>)
Ответы Re: ERROR: catalog is missing 9 attribute(s) for relid 10297  ("O'Shea, Brendan" <boshea@akamai.com>)
Список pgsql-general
"O'Shea, Brendan" <boshea@akamai.com> writes:
> pg_dump: reading schemas
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  catalog is missing 9
> attribute(s) for relid 10297

Ugh.  Does it work if you do

    export PGOPTIONS="--ignore_system_indexes=1"

first?  If so, the problem would evidently be corruption of the indexes
for pg_attribute, specifically pg_attribute_relid_attnum_index.  It
seems pretty suspicious that lightning would strike twice in the same
place ...

            regards, tom lane

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2 headline options
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Mandatory AS keyword in SELECT statements