Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 93C922E0094 for ; Wed, 13 Feb 2008 15:32:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59164-07 for ; Wed, 13 Feb 2008 15:32:30 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by postgresql.org (Postfix) with ESMTP id 8E4AA2E00F1 for ; Wed, 13 Feb 2008 15:32:32 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so105074wxc.28 for ; Wed, 13 Feb 2008 11:32:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=q5Lgg4z4fAUa36WzL9KVXGS6bvCTdT49o6RzoAYJVZo=; b=AjdNQmr/tkFmhsJtPA0wvEsG+pCK5GakTIxq3hcxV6f5ko99bDn9Ri0JLjmgeSAzZ4DU1gsNVrkyDnx0B9bI4miNNDtOb+J+F0N+pgPDjrcsK2ztB5zf1hJ9/HAY62U0LO3PmoimEuA8+D4LmLNd31SLcekNnXbH6P0bxyCq+Yw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=h+PiahXRbE+T762dZhVmnZIoPP7Bp6jju35Rac/bOyQl22QW/L9ylo3eX19czN1z7G33gtE4i+7XpYGGgLom7FSjEbiVQwBiXWbgzmAw0dQTBCa3sZk9RNW3jI/dTmauySlbOuQZkpyPpksFBy8/Q3g3ffErj1FnWfzSrR5+/Lo= Received: by 10.141.86.14 with SMTP id o14mr210165rvl.278.1202931150585; Wed, 13 Feb 2008 11:32:30 -0800 (PST) Received: by 10.141.18.20 with HTTP; Wed, 13 Feb 2008 11:32:30 -0800 (PST) Message-ID: Date: Wed, 13 Feb 2008 13:32:30 -0600 From: "Michael Shapiro" To: "Michael Fuhr" Subject: Re: CONTEXT messages for raise EXCEPTION Cc: pgsql-admin@postgresql.org In-Reply-To: <20080213191136.GA91063@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15604_5078147.1202931150564" References: <20080213191136.GA91063@winnie.fuhr.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/158 X-Sequence-Number: 28232 ------=_Part_15604_5078147.1202931150564 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I tried setting dbh->{pg_errorlevel} = 0 and 2 Neither setting produced the CONTEXT messages. 0 wasn't any different that 1, and 2 added LOCATION: exec_stmt_raise, pl_exec.c:2113 On Feb 13, 2008 1:11 PM, Michael Fuhr wrote: > On Wed, Feb 13, 2008 at 11:27:16AM -0600, Michael Shapiro wrote: > > I am getting a lot of CONTEXT information along with the message when an > > EXCEPTION is raised. Does anyone know what controls whether EXCEPTIONS > add > > the CONTEXT or not? > > In the server logs the log_error_verbosity configuration setting > controls how much much detail is logged. For client-side display, > in psql you can use the VERBOSITY variable. > > > NOTE: We are using Perl's DBI (which may or not be the cause). > > For client-side display, see the pg_errorlevel database handle > attribute in the DBD::Pg manual page. > > $dbh->{pg_errorlevel} = 0; # terse > $dbh->{pg_errorlevel} = 1; # default > $dbh->{pg_errorlevel} = 2; # verbose > > -- > Michael Fuhr > ------=_Part_15604_5078147.1202931150564 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I tried setting dbh->{pg_errorlevel} = 0 and 2
Neither setting produced the CONTEXT messages. 0 wasn't any different that 1, and 2 added
LOCATION:  exec_stmt_raise, pl_exec.c:2113


On Feb 13, 2008 1:11 PM, Michael Fuhr <mike@fuhr.org> wrote:
On Wed, Feb 13, 2008 at 11:27:16AM -0600, Michael Shapiro wrote:
> I am getting a lot of CONTEXT information along with the message when an
> EXCEPTION is raised. Does anyone know what controls whether EXCEPTIONS add
> the CONTEXT or not?

In the server logs the log_error_verbosity configuration setting
controls how much much detail is logged.  For client-side display,
in psql you can use the VERBOSITY variable.

> NOTE:  We are using Perl's DBI (which may or not be the cause).

For client-side display, see the pg_errorlevel database handle
attribute in the DBD::Pg manual page.

$dbh->{pg_errorlevel} = 0;  # terse
$dbh->{pg_errorlevel} = 1;  # default
$dbh->{pg_errorlevel} = 2;  # verbose

--
Michael Fuhr

------=_Part_15604_5078147.1202931150564--