Re: Relation does not exist - Mailing list pgsql-general

From Tom Lane
Subject Re: Relation does not exist
Date
Msg-id 287.1092162628@sss.pgh.pa.us
Whole thread Raw
In response to Relation does not exist  ("Rob Klaus" <rob@unique-mgmt.com>)
List pgsql-general
"Rob Klaus" <rob@unique-mgmt.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

pgsql-general by date:

Previous
From: "Rob Klaus"
Date:
Subject: Re: Relation does not exist
Next
From: David Garamond
Date:
Subject: psql: immediately exit after an error?