Re: prepared statements don't log arguments?

From: Palle Girgensohn
Subject: Re: prepared statements don't log arguments?
Date: ,
Msg-id: E5C666E5EDCC39097DAD572E@rambutan.pingpong.net
(view: Whole thread, Raw)
In response to: Re: prepared statements don't log arguments?  (Oliver Jowett)
List: pgsql-hackers

Tree view

prepared statements don't log arguments?  (Palle Girgensohn, )
 Re: prepared statements don't log arguments?  (Greg Stark, )
  Re: prepared statements don't log arguments?  (Christopher Kings-Lynne, )
   Re: prepared statements don't log arguments?  (Neil Conway, )
    Re: prepared statements don't log arguments?  (Abhijit Menon-Sen, )
    Re: prepared statements don't log arguments?  (Alvaro Herrera, )
    Re: prepared statements don't log arguments?  (Oliver Jowett, )
     Re: prepared statements don't log arguments?  (Neil Conway, )
     Re: prepared statements don't log arguments?  (Tom Lane, )
  Re: prepared statements don't log arguments?  (Oliver Jowett, )
   Re: prepared statements don't log arguments?  (Palle Girgensohn, )
 Re: prepared statements don't log arguments?  (Simon Riggs, )
  Re: prepared statements don't log arguments?  (Palle Girgensohn, )
   Re: prepared statements don't log arguments?  (Simon Riggs, )
    Re: prepared statements don't log arguments?  (Oliver Jowett, )
     Re: prepared statements don't log arguments?  (Tom Lane, )
      Re: prepared statements don't log arguments?  (Simon Riggs, )
       Re: prepared statements don't log arguments?  (Oliver Jowett, )
        Re: prepared statements don't log arguments?  (Simon Riggs, )
         Re: prepared statements don't log arguments?  (Oliver Jowett, )

--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 by date:

From: Karel Zak
Date:
Subject: 'now' runtime
From: Alvaro Herrera
Date:
Subject: Re: Shared row locking, revisited