Re: PostgreSQL 8.1.0 catalog corruption

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL 8.1.0 catalog corruption
Дата
Msg-id 4469.1132609403@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL 8.1.0 catalog corruption  (Bob Ippolito <bob@redivi.com>)
Ответы Re: PostgreSQL 8.1.0 catalog corruption  (Bob Ippolito <bob@redivi.com>)
Список pgsql-hackers
Bob Ippolito <bob@redivi.com> writes:
> I don't know how to get the oid of a type.. but there are certainly  
> entries in pg_depend with the other criteria:

Hmph, looks like you still have a pretty full set of dependencies for
the table.  What about attributes --- tryselect attname from pg_attribute where attrelid = 211174567;

It might be interesting to try reindexing pg_class, too ... maybe the
pg_class row is still there but isn't being found because of a corrupt
index?
        regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Data directory on read-only media
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: why is gist index taking so much space on the disc