Re: PostgreSQL 8.0 can't print duration in log when client - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: PostgreSQL 8.0 can't print duration in log when client
Date
Msg-id 422F6B34.5040207@opencloud.com
Whole thread Raw
In response to PostgreSQL 8.0 can't print duration in log when client uses 8.0 jdbc driver  (Ryszard Lach <siaco@autograf.pl>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL
Next
From: "Prasanth"
Date:
Subject: Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL