Re: prepared statements don't log arguments?

Список
Период
Сортировка
От Palle Girgensohn
Тема Re: prepared statements don't log arguments?
Дата
Msg-id E5C666E5EDCC39097DAD572E@rambutan.pingpong.net
обсуждение исходный текст
Ответ на Re: prepared statements don't log arguments?  (Oliver Jowett)
Список pgsql-hackers
--On torsdag, april 07, 2005 14.34.22 +1200 Oliver Jowett 
<> wrote:

> Greg Stark wrote:
>> Palle Girgensohn <> writes:
>>
>>> When setting log_statement = all, and using JDBC PreparedStatements, I
>>> get $n in the log where the real arguments used to be in previous
>>> versions of postgresql:
>
>> You might want to look into JDBC options to disable use of prepared
>> statements. The old emulation code must still be there in case it runs
>> against a <=7.4 database so perhaps there's an option to use it.
>
> You can do this by appending '?protocolVersion=2' to the JDBC URL you
> use (or '&protocolVersion=2' if you already have other URL parameters).
>
> If you do this you also lose any features that need V3 protocol support
> (e.g. query parameter metadata and some resultset metadata).

OK, thanks. Still, I think I do need V3 stuff... Is it not possible to log 
the arguments, somehow? Seems strange?

/Palle



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

Предыдущее
От: Alexey Slynko
Дата:
Сообщение: About index_build
Следующее
От: Karel Zak
Дата:
Сообщение: 'now' runtime