Re: prepared statements don't log arguments? - Mailing list pgsql-hackers

From Palle Girgensohn
Subject Re: prepared statements don't log arguments?
Date
Msg-id E5C666E5EDCC39097DAD572E@rambutan.pingpong.net
Whole thread Raw
In response to Re: prepared statements don't log arguments?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-hackers
--On torsdag, april 07, 2005 14.34.22 +1200 Oliver Jowett 
<oliver@opencloud.com> wrote:

> Greg Stark wrote:
>> Palle Girgensohn <girgen@pingpong.net> 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 by date:

Previous
From: Alexey Slynko
Date:
Subject: About index_build
Next
From: Karel Zak
Date:
Subject: 'now' runtime