From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Logging of sql statements? |
Date: | 2006-03-23 16:17:38 |
Message-ID: | 1143130657.17999.52.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)kretschmer(at)schollglas(dot)com> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2006-03-23 16:21:38 | Re: Logging of sql statements? |
Previous Message | Bjørn T Johansen | 2006-03-23 16:09:52 | Re: Logging of sql statements? |