On Fri, 2007-06-22 at 10:00 -0400, Tom Lane wrote:
> > I need to have log_duration at 0 so I log EVERY call from the jdbc to
> > the postgresql because that's excellent way of debuging the dataflow
> > from the middle-tier to the application.
> That is a job for log_statement not log_duration.
Thnx, that makes sense now :) I guess I overlooked log_statement for
some reason in pg8.0.
Altough I'd like to see this:
SELECT LOG: execute <unnamed>: select * from ad_get('104', '2007-07-02
SELECT LOG: execute <unnamed>: select * from ad_get($1, $2, $3) as
SELECT DETAIL: parameters: $1 = '104', $2 = '2007-07-02 14:36:57.361
+02', $3 = '109'
Yes, I know, prepared statements, but still..
In response to
pgsql-jdbc by date
|Next:||From: Guy Rouillier||Date: 2007-07-02 15:38:16|
|Subject: Re: Replace usage of a table in query with its array values|
|Previous:||From: Loredana Curugiu||Date: 2007-07-02 08:23:58|
|Subject: Replace usage of a table in query with its array values|