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
