"Sinead O Brien" <reapersoul@xxxxxxxxxxx> 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
