On Monday 26 October 2009 5:48:42 am Radcon Entec wrote: > 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 http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html See: log_min_error_statement (string) -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
