From: Michael Shapiro <mshapiro51@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: CONTEXT messages for raise EXCEPTION
Date: Wed, 13 Feb 2008 13:32:30 -0600
Message-ID: <ca3a8da20802131132i11fa274ere86300a5ed78e743@mail.gmail.com> (raw)
In-Reply-To: <20080213191136.GA91063@winnie.fuhr.org>
References: <ca3a8da20802130927u1abe9c2cgf67dfe83bb159592@mail.gmail.com>
<20080213191136.GA91063@winnie.fuhr.org>
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
>
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: mshapiro51@gmail.com, mike@fuhr.org
Subject: Re: CONTEXT messages for raise EXCEPTION
In-Reply-To: <ca3a8da20802131132i11fa274ere86300a5ed78e743@mail.gmail.com>
* 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