Re: did not find any relation for existing table

"Sinead O Brien" <reapersoul@hotmail.com> writes:
>>> I am receiving a "did not find any relation" error in pgsql for a table
>>> which I know exists.
>>
>> Hm, what PG version is this?  It might be that reindexing pg_class will
>> fix it, but it would be nice to try to determine what's wrong before
>> overwriting the evidence.
>>
> Thanks for the response, version is
> psql (PostgreSQL) 8.0.3

8.0.3 is more than two years old --- you really ought to update to the
latest in that branch (8.0.13 currently), if not upgrade to 8.1.x or
8.2.x branches.  I do see a post-8.0.3 fix that might explain loss of
index entries, so trying a reindex is worth doing at this point.

            regards, tom lane