Re: Log actual params for prepared queries: TO-DO item?

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Log actual params for prepared queries: TO-DO item?
Date: 2006-07-17 05:10:12
Message-ID: c2d9e70e0607162210jf111ebev7df72fcc33a1b273@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/15/06, Ed L. <pgsql(at)bluepolka(dot)net> wrote:
>
> We'd like to attempt some log replay to simulate real loads, but
> in 8.1.2, it appears the formal parameters are logged ('$')
> instead of the actuals for prepared queries, e.g.:
>
> EXECUTE <unnamed> [PREPARE: UPDATE sessions SET a_session = $1
> WHERE id = $2]
>
> Thoughts on making this a to-do item?
>
> Ed
>

i think this is the one you are requesting, it's a TODO item already:

o Allow protocol-level BIND parameter values to be logged

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Smith 2006-07-17 06:56:31 permission to create user
Previous Message Ron Johnson 2006-07-17 04:59:56 Re: Scaleable DB structure for counters...