Обсуждение: log_min_error_statement and parameters value

Поиск
Список
Период
Сортировка

log_min_error_statement and parameters value

От
"JEAN-PIERRE PELLETIER"
Дата:
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




Re: log_min_error_statement and parameters value

От
Tom Lane
Дата:
"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