Search Postgresql Archives

just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

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

Earlier versions logged the failed query as well, which made it a lot easier 
to cut&paste queries generated by applications in development in order to 
hunt down the problem.

- psql follows up on the error by printing the line where it occured

- setting log_error_verbosity to 'verbose' doesn't log the query itself either


Is there a way to get the failed query into the log, or should it have been 
there in the first place?





-- 
Best,




Frank.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux