Re: PostgreSQL 8.0 can't print duration in log when client

Ryszard Lach wrote:

> I noticed, that PostgreSQL cannot print statement duration when a Java
> client is using JDBC driver (I've tested with JDK1.4.2 and JDBC-2 and
> JDBC-3 postgresql8 drivers). Changing driver to 7.4 (JDBC-3) solves the
> problem. Strange, isn't it?

This is likely to be because the newer driver uses the extended-query
protocol. Current backends don't handle logging of the extended-query
protocol very well, I guess that statement duration logging is another
manifestation of this.

-O