Re: Logging statements and parameter values

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ted Powell <ted(at)psg(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Logging statements and parameter values
Date: 2006-01-30 22:19:23
Message-ID: 200601302219.k0UMJNW24328@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Ted Powell wrote:
> On Mon, Jan 30, 2006 at 04:31:29PM -0500, Bruce Momjian wrote:
> >
> > I assume it is this TODO:
> >
> > * Allow protocol-level BIND parameter values to be logged
> >
> >
> > ---------------------------------------------------------------------------
> >
> > Ted Powell wrote:
> > > Our development group needs to have the option of logging all SQL
> > > statements including substituted parameter values. [...]
>
> That's it! (I should have thought to look in the TODO.)
>
> Has any design work been done on this?

No. I am with Simon Riggs today at my house and I asked him, hoping he
can get it done for 8.2. I don't think it is very hard.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-01-30 22:28:08 Re: Transaction safety and large objects. Possible?
Previous Message John Zubac 2006-01-30 22:13:45 Rotation of security logs in Postgres 7.4.11

Browse pgsql-hackers by date

  From Date Subject
Next Message Ted Powell 2006-01-30 22:30:47 Re: Logging statements and parameter values
Previous Message Tom Lane 2006-01-30 22:10:03 Re: Policy on schema-qualified names