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.