| From: | "Nykolyn, Andy (AS)" <andrew(dot)nykolyn(at)ngc(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | "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 19:02:56 |
| Message-ID: | 3F116676B62050438121BFAB3F3CAA3112CAA75B@XMBVAG75.northgrum.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Are you using EXECUTE or doing a straight CREATE TEMP TABLE ...?
Maybe a sample with sensitive info changed?
The insert you mention happens in the same procedure or is there a nested
procedure?
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
Is there a database pooler in the mix?
Are there any other errors in the logs at the same time that might pertain?
There is no database pooler and there are never any other errors in the log at the time of this error.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2012-01-31 20:02:59 | Re: pg_dump -s dumps data?! |
| Previous Message | Adrian Klaver | 2012-01-31 18:16:16 | Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation |