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.klaver@gmail.com