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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073