Re: [HACKERS] pg_inherits: not found, but visible [IT GETS WORSE]

2001-03-20 Thread Tom Lane
Joel Burton <[EMAIL PROTECTED]> writes: > Yikes. It gets weirder. > Fixed the pg_inherits problem, went back to my Zoping, trying to optimize > some views, and during another run, get an error that trelclasspq, one of > my tables, couldn't open. > Trying this out in psql, I get the same error mess

Re: [HACKERS] pg_inherits: not found, but visible [IT GETS WORSE]

2001-03-20 Thread Joel Burton
On Tue, 20 Mar 2001, Ross J. Reedstrom wrote: > What kind of filesystem is the pgsql data tree living on? If you do a fsck, > does anything turn up in lost+found? > > Ross ext2, straight out of the box. It's in /var, which is a separate partition. fscking shows no errors, tells no lies, and no

Re: [HACKERS] pg_inherits: not found, but visible [IT GETS WORSE]

2001-03-20 Thread Ross J. Reedstrom
On Tue, Mar 20, 2001 at 08:03:16PM -0500, Joel Burton wrote: > > Yikes. It gets weirder. > > > I have > > Zope 2.3.1b2 (most recent version of Zope) > running on a Linux-Mandrake 7.2 box (server #1) > What kind of filesystem is the pgsql data tree living on? If you do a fsck, does anything t

Re: [HACKERS] pg_inherits: not found, but visible [IT GETS WORSE]

2001-03-20 Thread Joel Burton
Yikes. It gets weirder. Fixed the pg_inherits problem, went back to my Zoping, trying to optimize some views, and during another run, get an error that trelclasspq, one of my tables, couldn't open. Trying this out in psql, I get the same error message--the file doesn't exist. And, getting the o

Re: [HACKERS] pg_inherits: not found, but visible

2001-03-20 Thread Joel Burton
On Wed, 21 Mar 2001, Hiroshi Inoue wrote: > Joel Burton wrote: > > > > On Wed, 21 Mar 2001, Hiroshi Inoue wrote: > > > > > Joel Burton wrote: > > > > > > > > Postmaster crashed on me, and on restart, pg_inherits cannot be found. > > > > I can see it in pg_class (and it shows up w/ \dS), but any

Re: [HACKERS] pg_inherits: not found, but visible

2001-03-20 Thread Joel Burton
On Tue, 20 Mar 2001, Tom Lane wrote: > Joel Burton <[EMAIL PROTECTED]> 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

Re: [HACKERS] pg_inherits: not found, but visible

2001-03-20 Thread Hiroshi Inoue
Joel Burton wrote: > > On Wed, 21 Mar 2001, Hiroshi Inoue wrote: > > > Joel Burton wrote: > > > > > > Postmaster crashed on me, and on restart, pg_inherits cannot be found. > > > I can see it in pg_class (and it shows up w/ \dS), but any attempt to > > > modify anything fails with "pg_inherits: N

Re: [HACKERS] pg_inherits: not found, but visible

2001-03-20 Thread Tom Lane
Joel Burton <[EMAIL PROTECTED]> 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

Re: [HACKERS] pg_inherits: not found, but visible

2001-03-20 Thread Joel Burton
On Wed, 21 Mar 2001, Hiroshi Inoue wrote: > Joel Burton wrote: > > > > Postmaster crashed on me, and on restart, pg_inherits cannot be found. > > I can see it in pg_class (and it shows up w/ \dS), but any attempt to > > modify anything fails with "pg_inherits: No such file or directory". > > >

Re: [HACKERS] pg_inherits: not found, but visible

2001-03-20 Thread Hiroshi Inoue
Joel Burton wrote: > > Postmaster crashed on me, and on restart, pg_inherits cannot be found. > I can see it in pg_class (and it shows up w/ \dS), but any attempt to > modify anything fails with "pg_inherits: No such file or directory". > > I've reindexed the database (w/postgres -P -O). Vacuumin