From: | "Michael Shapiro" <mshapiro51(at)gmail(dot)com> |
---|---|
To: | "Michael Fuhr" <mike(at)fuhr(dot)org> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: CONTEXT messages for raise EXCEPTION |
Date: | 2008-02-13 19:25:47 |
Message-ID: | ca3a8da20802131125if8cb921h2912f2b41c262bb0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
The $dbh->{errorlevel} is set to 1 (default), which implies the extra
verbosity is some setting in the server, right?
The server log_error_verbosity is set to terse, so the server shouldn't add
the CONTEXT.
I remain baffled by what I am seeing.
On Feb 13, 2008 1:11 PM, Michael Fuhr <mike(at)fuhr(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Shapiro | 2008-02-13 19:32:30 | Re: CONTEXT messages for raise EXCEPTION |
Previous Message | Michael Fuhr | 2008-02-13 19:11:36 | Re: CONTEXT messages for raise EXCEPTION |