Re: Prepared query logging omits bind values

Jon Jensen wrote:
> On Fri, 23 Sep 2005, Bruce Momjian wrote:
>
> >> Is it true that there is no option to log prepared query bind values?
> >
> > We are working on improve this for 8.1.  I assume you are talking about
> > protocol prepare rather than the PREPARE statement, which should be
> > logged.
>
> Yes, I mean protocol prepare. I assume the PREPARE/EXECUTE statements are
> fully logged, since the data is in the statements themselves, whereas
> with protocol prepare the data is out of band.

Right.

> > Even in 8.1 we don't log the bind values, but we should.
>
> Is this something that could go into 8.1, or is it too late for that? In
> either case, is someone already working on a patch for this?

Simon Riggs is working on a patch to output the prepare and execute
phases, but it does not output the BIND parameters.  I asked for that
addition yesterday, but I doubt this will make it into 8.1.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073