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

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Ryszard Lach <siaco(at)autograf(dot)pl>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.0 can't print duration in log when client
Date: 2005-03-09 21:31:32
Message-ID: 422F6B34.5040207@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Prasanth 2005-03-09 21:53:43 Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL
Previous Message Oliver Jowett 2005-03-09 21:22:36 Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL