--On torsdag, april 07, 2005 14.34.22 +1200 Oliver Jowett <[EMAIL PROTECTED]> wrote:
Greg Stark wrote:Palle Girgensohn <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
