Logging statements with errors in PostgreSQL 8.1

From: Radcon Entec <radconentec(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging statements with errors in PostgreSQL 8.1
Date: 2009-10-26 12:48:42
Message-ID: 756101.15448.qm@web43409.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings!

I am using PostgreSQL 8.3, as are most of our customers. But we still have at least one who is using PostgreSQL 8.1. The log files from that customer are showing repeated syntax errors, but they are not giving me any information about where the errors are coming from. Here's a sample from an old 8.1 installation on my machine:

2009-06-02 13:26:32 user postgres ERROR: syntax error at or near "OWNED" at character 39
2009-06-02 13:26:32 user postgres ERROR: syntax error at or near "OWNED" at character 45
2009-06-02 13:26:32 user postgres ERROR: syntax error at or near "OWNED" at character 62
2009-06-02 13:26:32 user postgres ERROR: syntax error at or near "OWNED" at character 53

On the other hand, my PostgreSQL 8.3 installation reports errors like this:

2009-10-21 15:16:45 EDT ERROR: relation "schedule_plan" does not exist
2009-10-21 15:16:45 EDT STATEMENT: select max_heating_rev_interval, max_cooling_rev_interval, name, high_heating_limit, low_heating_limit, high_heating_correction, low_heating_correction, high_cooling_limit, low_cooling_limit, high_cooling_correction, low_cooling_correction from schedule_plan

Is there any way to get a PostgreSQL 8.1 installation to report the statements that caused the error, as the 8.3 installation does?

I notice that the 8.3 log file also reports (frequently) loading the plugin_debugger.dll library. Is the problem that that library was not available in 8.1?

Thanks very much!

RobR

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-10-26 13:15:26 joining an array with a table or...?
Previous Message Pavel Stehule 2009-10-26 12:07:20 Re: cursor MOVE vs OFFSET in SELECT