Skip site navigation (1) Skip section navigation (2)

log_min_error_statement and parameters value

From: "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: log_min_error_statement and parameters value
Date: 2006-12-21 15:10:07
Message-ID: BAY133-F177895C5826403BF34DC3195CE0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-hackers
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



Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-12-21 15:22:41
Subject: Re: log_min_error_statement and parameters value
Previous:From: Simon RiggsDate: 2006-12-21 15:04:43
Subject: Re: Interface for pg_autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group