Re: prepared statements don't log arguments?

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: girgen(at)pingpong(dot)net
Subject: Re: prepared statements don't log arguments?
Date: 2005-04-07 02:34:22
Message-ID: 42549C2E.7010404@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark wrote:
> Palle Girgensohn <girgen(at)pingpong(dot)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).

-O

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike G. 2005-04-07 03:11:06 Did this issue ever get resolved?
Previous Message Neil Conway 2005-04-07 02:33:25 Re: prepared statements don't log arguments?