Re: pg_inherits: not found, but visible

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