Steve Peterson wrote: > Any known way to log at the JDBC level? When I get a little time I'm > going to write a test that bypasses Eclipse and SQLExplorer. > > On Wed, 5 Oct 2005, Oliver Jowett wrote: > > > Alvaro Herrera wrote: > > > On Fri, Sep 30, 2005 at 10:37:05PM -0500, Steve Peterson wrote: > > > > > >>The query is submitted using the JDBC driver, via > > >>the SQLExplorer plugin for Eclipse. > > >> > > >>Is there a way for me to see the query as it was > > >>submitted to the backend? If so I'll take a look and see what it looks > > >>like. > > > > > > > > > Sure. Use the log_statement configuration parameter in postgresql.conf. > > > > This won't log anything with recent JDBC drivers and pre-8.1 backends.
This will be fixed in 8.1. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
