| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Nykolyn, Andy (AS)" <andrew(dot)nykolyn(at)ngc(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation |
| Date: | 2012-01-31 21:19:44 |
| Message-ID: | 10719.1328044784@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Nykolyn, Andy (AS)" <andrew(dot)nykolyn(at)ngc(dot)com> writes:
> It is a straight CREATE TEMP TABLE. It does not happen on the same procedure every time. It happens on different procedures sometimes they are nested. These store procedures have been working for many years the same way. Only recently has this error been intermittently occurring on temp tables. Sometimes it occurs on the create, sometimes it occurs on 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | xavieremv | 2012-01-31 21:41:01 | Re: INSERT with RETURNING clause inside SQL function |
| Previous Message | Tom Lane | 2012-01-31 21:14:40 | Re: Gist cost estimates |