From: | Kevin Dorne <kevin(at)catalyst(dot)net(dot)nz> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Printing query durations |
Date: | 2006-03-28 04:33:52 |
Message-ID: | 4428BCB0.2040002@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Tom Lane wrote:
> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>> There is no difference between a jdbc query and a psql query. The
>> backend doesn't know where the query comes from.
>
> However, the backend has different code paths for V2 and V3 protocol,
> and it could be that what he's looking at is a deficiency in the V3
> protocol logging support. If so, telling jdbc to use V2 would help.
> (I'm being tentative about this because the backend version was not
> mentioned --- we've fixed some of that stuff in recent releases.)
Well, to clarify, we're using PostgreSQL 7.4.7. I'm not actually sure
what JDBC version we're using, as I've just encountered a
(usefully-named) postgresql.jar file, but I'm fairly certain it's an
8.1.x. Is there an easy way to tell?
And yes, we are using V3 protocol.
-k
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-03-28 10:32:36 | Re: Printing query durations |
Previous Message | Dave Cramer | 2006-03-28 03:34:24 | Re: Printing query durations |