Re: Logging statements with errors in PostgreSQL 8.1

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(at)comcast(dot)net