Postgres Pro
Downloads
Home   >   mailing lists

Can we adjust postgres logging to also dump the bind variable data when an error occurs - Mailing list pgsql-admin

From bfraci@aol.com
Subject Can we adjust postgres logging to also dump the bind variable data when an error occurs
Date
Msg-id 8C83B8555225B23-1658-67F4@FWM-D25.sysops.aol.com
Whole thread Raw
Responses Re: Can we adjust postgres logging to also dump the bind variable data when an error occurs  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
Tree view
I am using Postgres version 8.0.3.  I have noticed that when I set the log_statement parameter to 'all', I get the values for the bind variables.  Is it possible to get all of the same information that I get when I set log_statement to 'all' just for the statement that has an error?  I don't want to clutter up my log file with this detail information for all statements, just those that produce an error.
 
Thanks for your help.
 
Brent

pgsql-admin by date:

Previous
From: jon
Date:
Subject: Re: Postmaster log perms and line suffix
Next
From: "Roger Dahlkvist (MO/EAB)"
Date:
Subject: ECCN coding