Re: pg_inherits: not found, but visible

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joel Burton <jburton(at)scw(dot)org>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_inherits: not found, but visible
Date: 2001-03-21 00:32:56
Message-ID: 19045.985134776@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joel Burton <jburton(at)scw(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2001-03-21 00:38:22 Re: pg_inherits: not found, but visible
Previous Message Lamar Owen 2001-03-21 00:25:24 Re: Beta 6 Regression results on Redat 7.0.