Search Postgresql Archives

Re: Logging of sql statements?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2006-03-23 at 14:50, Bjørn T Johansen wrote:
> On Thu, 23 Mar 2006 17:21:38 +0100
> Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote:
> 
> > Bjørn T Johansen <btj@xxxxxxxxxx> schrieb:
> > > > Set in your postgresql.conf:
> > > > 
> > > > log_statement = all
> > > > 
> > > > Since 8.0 oder 8.1, there you can see parameters in prepared statements.
> > > > 
> > > > 
> > > > 
> > > > HTH, Andreas
> > > 
> > > 
> > > This is what I am already using and it doesn't work...
> > 
> > It works for me ;-)
> > 
> > test=# prepare my_foo(int) as select * from foo where id = $1;
> > PREPARE
> > test=#
> > test=# execute my_foo(1);
> >  id | x
> > ----+----
> >   1 | 10
> > (1 row)
> > 
> > 
> > In my log:
> > LOG:  statement: prepare my_foo(int) as select * from foo where id = $1;
> > LOG:  statement: execute my_foo(1);  [client PREPARE:  prepare my_foo(int) as select * from foo where id =
> > $1;]
> > 
> > 
> > test=# select version();
> >                                                    version
> > --------------------------------------------------------------------------------------------------------------
> >  PostgreSQL 8.1.2 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 20060104 (prerelease) (Debian
> > 4.0.2-6) (1 row)
> > 
> > 
> > 
> > HTH, Andreas
> 
> If I try the same from a client, I get the same result.. But when running from my webapp (using Hibernate),
> only question marks appear....?

Again, I'm pretty sure this is a known issue with the JDBC driver
version.  If you can force your JDBC driver to run under the previous
protocol, you should get the old behaviour.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux