View Single Post

   
  #1 (permalink)  
Old 04-12-2008, 07:06 AM
JEAN-PIERRE PELLETIER
 
Posts: n/a
Default 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



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

Reply With Quote