SEO

#1 (**permalink**) 04-12-2008, 06:06 AM

Hi,

In PostgreSQL 8.2, log_statement display actual parameters value which is
very neat as in
DETAIL: parameters: $1 = '1', $2 = NULL

Currently I used log_statement='all' to display all statements and their
parameters but
that produced a lot of output and I am really only interested in the
statements displayed with log_min_error_statement.

Is it possible to set log_min_error_statement to display the parameters
value?

Thanks,
Jean-Pierre Pelletier
e-djuster

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-12-2008, 06:07 AM

"JEAN-PIERRE PELLETIER" <pelletier_32@sympatico.ca> writes:
> Is it possible to set log_min_error_statement to display the parameters
> value?

No --- displaying the parameter values requires being able to run
user-defined output functions, which we can't do in an already-failed
transaction.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

log_min_error_statement and parameters value