Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation - Mailing list pgsql-general

From Tom Lane
Subject Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation
Date
Msg-id 10719.1328044784@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation  ("Nykolyn, Andy (AS)" <andrew.nykolyn@ngc.com>)
List pgsql-general
"Nykolyn, Andy (AS)" <andrew.nykolyn@ngc.com> writes:
> It is a straight CREATE TEMP TABLE.  It does not happen on the same procedure every time.  It happens on different
proceduressometimes they are nested.  These store procedures have been working for many years the same way.  Only
recentlyhas this error been intermittently occurring on temp tables.  Sometimes it occurs on the create, sometimes it
occurson an insert, update or delete on a temp table 

8.4.what exactly, and did you update versions around the time this
started happening?  I'm worried that this may represent a
newly-introduced bug.  Can you provide a self-contained test case?
It doesn't matter if it only fails occasionally, as long as we can
keep running it till it does fail.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Gist cost estimates
Next
From: Tom Lane
Date:
Subject: Re: list blocking queries