log_min_error_statement and parameters value
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
"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