Re: pg_inherits: not found, but visible - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_inherits: not found, but visible
Date
Msg-id 19045.985134776@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_inherits: not found, but visible  (Joel Burton <jburton@scw.org>)
Responses Re: pg_inherits: not found, but visible
Re: pg_inherits: not found, but visible [IT GETS WORSE]
List 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 by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Beta 6 Regression results on Redat 7.0.
Next
From: Hiroshi Inoue
Date:
Subject: Re: pg_inherits: not found, but visible