Re: Can we adjust postgres logging to also dump the bind variable data when an error occurs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, May 01, 2006 at 06:25:49PM -0400, bfraci@xxxxxxx 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 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.

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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux