Re: Prepared query logging omits bind values

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.

> 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?

Thanks,
Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/