Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim C. Nasby
Subject Re: Can we adjust postgres logging to also dump the bind variable data when an error occurs
Date
Msg-id 20060504181303.GP97354@pervasive.com
Whole thread Raw
In response to Can we adjust postgres logging to also dump the bind variable data when an error occurs  (bfraci@aol.com)
List pgsql-admin
Tree view 
On Mon, May 01, 2006 at 06:25:49PM -0400, bfraci@aol.com wrote:
> I am using Postgres version 8.0.3.  I have noticed that when I set the log_statement parameter to 'all', I get the
valuesfor 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
allstatements, just those that produce an error. 

Setting log_error_verbosity to verbose might do the trick...
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-admin by date:

Previous
From: "renneyt@yahoo.com"
Date:
Subject: Re: backup problem
Next
From: "Shivaji S"
Date:
Subject: How to find current running process