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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
