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@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
