Re: CONTEXT messages for raise EXCEPTION - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: CONTEXT messages for raise EXCEPTION
Date
Msg-id 20080213191136.GA91063@winnie.fuhr.org
Whole thread Raw
In response to CONTEXT messages for raise EXCEPTION  ("Michael Shapiro" <mshapiro51@gmail.com>)
Responses Re: CONTEXT messages for raise EXCEPTION  ("Michael Shapiro" <mshapiro51@gmail.com>)
Re: CONTEXT messages for raise EXCEPTION  ("Michael Shapiro" <mshapiro51@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Peter Kovacs"
Date:
Subject: How much space do database objects take up in data files
Next
From: "Michael Shapiro"
Date:
Subject: Re: CONTEXT messages for raise EXCEPTION