Well I have been running the function using the data you sent against both an
8.4.1 and 8.4.9 instance on and off a good part of the day. At this point we
are
talking many thousands of runs. In either case I have not seen an error. So
either I am incredibly lucky(I wish) or something is going o
On Wednesday, February 01, 2012 4:55:46 am Nykolyn, Andy (AS) wrote:
>
> Tom,
>
> It is version 8.4.1 and it has been that for almost 3 years. I have
> attached a script that will create and load the tables as well as the
> store procedure required to run the case that sometimes causes this err
"Nykolyn, Andy (AS)" writes:
>> 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 ca
"Nykolyn, Andy (AS)" 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
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 happen
On Tuesday, January 31, 2012 9:42:07 am Nykolyn, Andy (AS) wrote:
>
> Some questions first:
> 1) What language are you using in the stored procedures?
> The stored procedures are in Pl/Pgsql
Temp table in PL/pgSQL was improved in 8.3 to handle this case, so you should
be
covered.
http://www.p
Subject: EXT :Re: [GENERAL] Intermittent occurrence of ERROR: could not open
relation
On Tuesday, January 31, 2012 8:08:24 am Nykolyn, Andy (AS) wrote:
> I have been running PostgreSQL 8.4 on Windows Server 2003 Service Pack 2
> for almost 3 years. I have recently been intermittently g
On Tuesday, January 31, 2012 8:08:24 am Nykolyn, Andy (AS) wrote:
> I have been running PostgreSQL 8.4 on Windows Server 2003 Service Pack 2
> for almost 3 years. I have recently been intermittently getting the error
> "ERROR: could not open relation base/85599592/121526263: No such file or
> dir
I have been running PostgreSQL 8.4 on Windows Server 2003 Service Pack 2 for
almost 3 years. I have recently been intermittently getting the error "ERROR:
could not open relation base/85599592/121526263: No such file or directory".
It only appears to be happening during the execution of store
