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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
