Re: cannot find attribute 1 of relation (of some user table) in 7.1.3

Tom Lane writes:
 > Dirk Lutzebaeck <lutzeb@aeccom.com> writes:
 > > Hi, I have the follow problem when vacuum'ing on 7.1.3:
 > > ERROR:  cannot find attribute 1 of relation docmatchsel
 > > Then I tried to reindex the table in standalone mode which gives:
 > > backend> reindex table docmatchsel force
 > > ERROR:  catalog is missing 4 attributes for relid 117042636
 >
 > Bizarre.  Were there four columns altogether?

Yes.

 > > docmatchsel was created as a temporary table in the application.
 >
 > Since it's only a temporary table, my counsel is:
 >
 >     1. delete from pg_class where relname = 'docmatchsel';
 >
 >     2. pg_dump, initdb, reload.
 >
 > You might be okay after just step 1, but given that we don't know what
 > caused this, an initdb seems like a good idea.

Ok, I will do this tonight.

 > It would be interesting to go groveling through pg_attribute and see if
 > we can find any traces of the missing attribute rows, but unless you're
 > prepared to sift through the bits yourself (or give access to some
 > developer to do it), that's not going to happen.

I would like to go with your fixes above this time. If it happens
again we should take a closer look indeed.

Thanks,

Dirk