Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.? - Mailing list pgsql-general

From Vivek Khera
Subject Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?
Date
Msg-id 446D33D9-B26A-4675-8874-90D64AB8B9A7@khera.org
Whole thread Raw
In response to just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
List pgsql-general
On Dec 28, 2005, at 9:46 AM, Frank van Vugt wrote:

> I may be overlooking some option here, but somewhere between the v7
> series and
> the current v8.1.1 that I'm using, failed queries stopped being
> logged, only
> the error message appears in the log (config option log_statement =
> all).
>
> I.e. executing
>
>     select 1 2;
>
> will result in just the logging of
>
>     ERROR:  syntax error at or near "2" at character 10
>

You want to set

log_min_error_statement = error


in your postgresql.conf file.  The default value of 'panic' seems
less than useful to me.


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: FW: deleted records
Next
From: Vivek Khera
Date:
Subject: Re: sending mail from Postgres