"Sinead O Brien" <reapersoul(at)hotmail(dot)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