From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: CONTEXT messages for raise EXCEPTION |
Date: | 2008-02-13 19:11:36 |
Message-ID: | 20080213191136.GA91063@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Shapiro | 2008-02-13 19:25:47 | Re: CONTEXT messages for raise EXCEPTION |
Previous Message | Peter Kovacs | 2008-02-13 18:43:36 | How much space do database objects take up in data files |