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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general