log_min_error_statement and parameters value

Started by JEAN-PIERRE PELLETIERabout 19 years ago2 messages
#1JEAN-PIERRE PELLETIER
pelletier_32@sympatico.ca

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: JEAN-PIERRE PELLETIER (#1)
Re: log_min_error_statement and parameters value

"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