Re: pg_inherits: not found, but visible

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_inherits: not found, but visible
Дата
Msg-id 19045.985134776@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_inherits: not found, but visible  (Joel Burton <jburton@scw.org>)
Ответы Re: pg_inherits: not found, but visible  (Joel Burton <jburton@scw.org>)
Re: pg_inherits: not found, but visible [IT GETS WORSE]  (Joel Burton <jburton@scw.org>)
Список pgsql-hackers
Joel Burton <jburton@scw.org> writes:
>> and I could find a $PGDATA/base/18720/16567 file.
>> Could you find such a file ?

> No. I do have the db directory, and all of the other file for the existing
> classes, but not this.

Hm.  You could make an empty file by that name (just 'touch' it) and
then you'd probably be able to dump (possibly after reindexing
pg_inherit's indexes again).  pg_inherits isn't a real critical table,
fortunately.

> Any ideas why this would disappear?

Interesting question, all right.  Did you have a system crash?
        regards, tom lane


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

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: Beta 6 Regression results on Redat 7.0.
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: pg_inherits: not found, but visible