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

Поиск
Список
Период
Сортировка
От Frank van Vugt
Тема just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?
Дата
Msg-id 200512281546.23835.ftm.van.vugt@foxi.nl
обсуждение исходный текст
Ответы Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?  (Vivek Khera <vivek@khera.org>)
Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Joshua Kramer
Дата:
Сообщение: Re: FW: Re[2]: new beginner to postgresql. Looking at it
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: sending mail from Postgres