pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Michael Shapiro <mshapiro51@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: CONTEXT messages for raise EXCEPTION
Date: Wed, 13 Feb 2008 12:11:36 -0700
Message-ID: <20080213191136.GA91063@winnie.fuhr.org> (raw)
In-Reply-To: <ca3a8da20802130927u1abe9c2cgf67dfe83bb159592@mail.gmail.com>
References: <ca3a8da20802130927u1abe9c2cgf67dfe83bb159592@mail.gmail.com>

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



view thread (5+ messages)  latest in thread

Message-ID: <20080213191136.GA91063@winnie.fuhr.org>
Permalink:  ../20080213191136.GA91063@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20080213191136.GA91063@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mike@fuhr.org, mshapiro51@gmail.com
  Subject: Re: CONTEXT messages for raise EXCEPTION
  In-Reply-To: <20080213191136.GA91063@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox