Обсуждение: Can we adjust postgres logging to also dump the bind variable data when an error occurs

Поиск
Список
Период
Сортировка

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

От
bfraci@aol.com
Дата:
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

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

От
"Jim C. Nasby"
Дата:
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