Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation

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 error.
> As I stated it happens on different types of DML statements but always on
> a temp table. The last line of the script contains the call to the stored
> procedure where the error had occurred most often when it occurred. The
> line it usually happened on was the "create temporary table t_bitgrid as
> select * from bitgrid" Please let me know if you need any more
> information. Greatly appreciated.

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 on that is unique to
your environment. At this point I am not quite where to go other then say, do
what Tom recommends, upgrade to 8.4.10.

>
> Andy Nykolyn
> Northrop Grumman

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com