On Saturday 15 March 2008 2:29 pm, Dave Potts wrote:
> I am using a 3rd front end to generate postgres requests , its reportng
> an error with the database.
>
> Is there anyway of loging which sql requests the application is actual
> sending to postgres. I need to known if the error is being created by
> the application generating invalid SQL or if there is a problem with the
> desgin of the database tables.
>
> Dave.
See:
http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html
In particular you will want to set log_statement to 'all' to see the SQL.
--
Adrian Klaver
aklaver(at)comcast(dot)net