Re: Relation does not exist

"Rob Klaus" <rob(at)unique-mgmt(dot)com> writes:
> We are having a problem where intermittently a query will not work,
> returning an error:
> ERROR: Relation "x" does not exist
> It will do this for a variable period, typically not lasting more than 5
> minutes

This certainly seems like a bug, but I have no idea what's causing it.
Can you characterize the conditions under which the bug appears or
disappears? What operation exactly is getting the error, and what sorts
of things are happening in parallel with it?

> We are using PG_VERSION 7.3 on RedHat 7.0

Hm. Red Hat 7.0 is positively ancient; you really ought to update. And
if you are running original PG 7.3 there are some very serious bugs that
you ought to fix by updating to 7.3.6 (if not 7.4.something). But I
can't say that I recognize your report as related to any of the known
bug fixes.

regards, tom lane