Prepared query logging omits bind values

Поиск
Список
Период
Сортировка
От Jon Jensen
Тема Prepared query logging omits bind values
Дата
Msg-id Pine.LNX.4.63.0509231212480.5548@ynfu.ovalna.fjrygre.arg
обсуждение исходный текст
Ответы Re: Prepared query logging omits bind values  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
PostgreSQL folks,

It appears that even with the most verbose logging options enabled,
PostgreSQL logs prepared queries like this:

     select * from transactions where code = $1

And never logs the bind values that correspond to $1, etc.

This instance I noticed is under PostgreSQL 7.4, both with fairly
default logging settings and with these settings in an attempt to
maximize the detail level:

     log_min_messages = debug5
     log_error_verbosity = verbose
     log_min_error_statement = debug5
     log_min_duration_statement = -1
     log_connections = true
     log_disconnections = true
     log_duration = true
     log_statement = 'all'
     log_hostname = false

I checked the docs for Pg 7.4 and 8.0, and didn't see any indication that
this is configurable.

Is it true that there is no option to log prepared query bind values? If
so, would a patch that enables this, either always or via a configuration
option, be welcome? Without the bind values, I am unable to retrace events
and discover the causes of problems.

Thanks,
Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PQtrace doesn't work
Следующее
От: Roy Souther
Дата:
Сообщение: Can not get ODBC to log. Trace is not working.