"Sinead O Brien" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to