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
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
