On Thu, 2006-03-23 at 10:09, Bjørn T Johansen wrote: > On Thu, 23 Mar 2006 14:25:52 +0100 > "A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx> wrote: > > > am 23.03.2006, um 14:07:11 +0100 mailte Bjørn T Johansen folgendes: > > > Is it possible to log the actual statement that the server runs? At the moment, the statement that is > > > logged, is logged using ? for parameters; I would like to log the statement after the parameters have been > > > substituted, isn't this possible in 8.1.x? (used to work in 7.x.x) > > > > Yes, this is possible. > > > > Set in your postgresql.conf: > > > > log_statement = all > > > > Since 8.0 oder 8.1, there you can see parameters in prepared statements. > > > > > > > > HTH, Andreas > > > This is what I am already using and it doesn't work... I was under the impression that back in the 7.x.y days, prepared statements got handled differently and could be logged with their parameters, but in 8.x.y, the way prepared statements are handled made this impossible. It's a memory from at least 6 months ago, so I could be messing it up a bit. Anyone with a better memory, please chime in.
