Re: [ADMIN] cannot find attribute 1 of relation (second occurrence.)

2002-05-21 Thread Tom Lane
"Nick Fankhauser" <[EMAIL PROTECTED]> writes: > No Problem- we'll do that. Is there a table that contains the mapping from > the database object names to the actual filenames? Look at the relfilenode column of pg_class for the individual file names, and at the OID column of pg_database for the di

Re: [ADMIN] cannot find attribute 1 of relation (second occurrence.)

2002-05-21 Thread Nick Fankhauser
Tom- No Problem- we'll do that. Is there a table that contains the mapping from the database object names to the actual filenames? -Nick > Next time it happens, would you shut down the > postmaster and make a copy of pg_attribute and its indexes (the physical > files) to send to me, before you

Re: [ADMIN] cannot find attribute 1 of relation (second occurrence.)

2002-05-21 Thread Tom Lane
"Nick Fankhauser" <[EMAIL PROTECTED]> writes: > We've just seen the following error for a second time since upgrading to > 7.2.1-2: > cannot find attribute 1 of relation > The first time, Tom Lane helped us by suggesting a reindex of pg_attribute. > I tried this on the second case as well, and it

[ADMIN] cannot find attribute 1 of relation (second occurrence.)

2002-05-21 Thread Nick Fankhauser
Hi- We've just seen the following error for a second time since upgrading to 7.2.1-2: cannot find attribute 1 of relation The first time, Tom Lane helped us by suggesting a reindex of pg_attribute. I tried this on the second case as well, and it solved the problem. At this point, I'm concerne