Thanks everbody I have isolated the issue
Davel,
Terry Fielder wrote:
You can turn up the verbosity of postgres logger to log all SQL
statements. Look in postgresql.conf
In particular, you can set postgres to log statements that take over x
milliseconds to execute. If you set log_min_duration_statement to 0,
then it will log ALL statements, which could also give you what you
want if you want to see all SQL statements.
Terry
Terry Fielder
terry@xxxxxxxxxxxxxxxxxx
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
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.
------------------------------------------------------------------------
begin:vcard
fn:David Potts
n:Potts;David
x-mozilla-html:FALSE
version:2.1
end:vcard
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
