Re: CONTEXT messages for raise EXCEPTION
| От | Michael Shapiro |
|---|---|
| Тема | Re: CONTEXT messages for raise EXCEPTION |
| Дата | |
| Msg-id | ca3a8da20802131132i11fa274ere86300a5ed78e743@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: CONTEXT messages for raise EXCEPTION (Michael Fuhr <mike@fuhr.org>) |
| Список | pgsql-admin |
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
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:In the server logs the log_error_verbosity configuration setting
> 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?
controls how much much detail is logged. For client-side display,
in psql you can use the VERBOSITY variable.For client-side display, see the pg_errorlevel database handle
> NOTE: We are using Perl's DBI (which may or not be the cause).
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 по дате отправления: