X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D1AE99FB1B9 for ; Mon, 1 May 2006 19:25:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 77399-09 for ; Mon, 1 May 2006 19:25:42 -0300 (ADT) X-Greylist: whitelisted by SQLgrey- Received: from imo-d20.mx.aol.com (imo-d20.mx.aol.com [205.188.139.136]) by postgresql.org (Postfix) with ESMTP id C47459FA2BE for ; Mon, 1 May 2006 19:25:42 -0300 (ADT) Received: from BFRACI@aol.com by imo-d20.mx.aol.com (mail_out_v38_r7.5.) id k.386.29bf29e (16099) for ; Mon, 1 May 2006 18:25:40 -0400 (EDT) Received: from FWM-D25 (fwm-d25.webmail.aol.com [205.188.162.1]) by air-id11.mx.aol.com (vx) with ESMTP id MAILINID113-3ee344568ae3119; Mon, 01 May 2006 18:25:40 -0400 Date: Mon, 01 May 2006 18:25:49 -0400 From: bfraci@aol.com Message-Id: <8C83B8555225B23-1658-67F4@FWM-D25.sysops.aol.com> X-MB-Message-Source: WebUI X-MB-Message-Type: User Received: from 67.106.37.5 by FWM-D25.sysops.aol.com (205.188.162.1) with HTTP (WebMailUI); Mon, 01 May 2006 18:25:48 -0400 X-Mailer: AOL WebMail 17385 Subject: Can we adjust postgres logging to also dump the bind variable data when an error occurs Content-Type: multipart/alternative; boundary="--------MailBlocks_8C83B8555166F5C_1658_6ECE_FWM-D25.sysops.aol.com" MIME-Version: 1.0 To: pgsql-admin@postgresql.org X-AOL-IP: 205.188.162.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/21 X-Sequence-Number: 21553 ----------MailBlocks_8C83B8555166F5C_1658_6ECE_FWM-D25.sysops.aol.com Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ----------MailBlocks_8C83B8555166F5C_1658_6ECE_FWM-D25.sysops.aol.com Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: 7bit
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
----------MailBlocks_8C83B8555166F5C_1658_6ECE_FWM-D25.sysops.aol.com--