Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1E8372E25E8 for ; Wed, 13 Feb 2008 15:16:40 -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 25809-01-5 for ; Wed, 13 Feb 2008 15:16:32 -0400 (AST) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id AED582E2D90 for ; Wed, 13 Feb 2008 15:11:43 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.8/8.13.8) with ESMTP id m1DJBbIp069265 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 13 Feb 2008 12:11:40 -0700 (MST) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.14.2/8.14.2) with ESMTP id m1DJBbG1091202; Wed, 13 Feb 2008 12:11:37 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.14.2/8.14.2/Submit) id m1DJBahk091201; Wed, 13 Feb 2008 12:11:36 -0700 (MST) (envelope-from mfuhr) Date: Wed, 13 Feb 2008 12:11:36 -0700 From: Michael Fuhr To: Michael Shapiro Cc: pgsql-admin@postgresql.org Subject: Re: CONTEXT messages for raise EXCEPTION Message-ID: <20080213191136.GA91063@winnie.fuhr.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/156 X-Sequence-Number: 28230 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