Skip site navigation (1) Skip section navigation (2)

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

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: cannot find attribute 1 of relation (of some user table) in 7.1.3
Date: 2002-01-13 20:52:38
Message-ID: 200201132052.g0DKqcd30964@cayambe.core.aeccom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi, I have the follow problem when vacuum'ing on 7.1.3:

db1=# vacuum;
ERROR:  cannot find attribute 1 of relation docmatchsel

I cannot drop the table either and the system does not seem do know
the columns:

db1=# \d docmatchsel
Table "docmatchsel
 Attribute | Type | Modifier
-----------+------+----------

db1=#

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

I also reindexed the system tables to no avail.

docmatchsel was created as a temporary table in the application. No
indexes were defined for this table.

I cannot get either run vacuum nor pg_dump with success.

Is there any insight to this? I looked up the email archives but could
find a way to get rid of this problem.

Dirk

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-01-13 23:45:20
Subject: Re: cannot find attribute 1 of relation (of some user table) in 7.1.3
Previous:From: Tom LaneDate: 2002-01-13 16:30:08
Subject: Re: ehm...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group