On 8/06/2010 8:25 PM, Jaiswal Dhaval Sudhirkumar wrote:
Hi All, We are getting following error on intermittent basis when we write data into database. We are on postgreSQL 8.0.2
While this doesn't help you track down your problem directly ... 8.0.2? Really? Version 8.0 is up to patch level 25 (!!) so you're missing out on a LOT of bug fixes. 8.0 needed plenty of them, too :S
Anyway, first I strongly recommend that you try to pg_dumpall and make sure you keep that dump somewhere other than the problem machine.
Next, I'd look at whether that report could be coming from a stored procedure that hadn't been re-loaded after a table/view/proc that it uses changed. Before 8.3, stored procedures had to be reloaded after such changes (and didn't work quite right with temp tables, either).
Then I'd turn up the log level and detail, and see if I could find out what statement was triggering the error report.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
