Re: prepared statements don't log arguments?

From: Alvaro Herrera
Subject: Re: prepared statements don't log arguments?
Date: ,
Msg-id: 20050407022308.GC25320@dcc.uchile.cl
(view: Whole thread, Raw)
In response to: Re: prepared statements don't log arguments?  (Neil Conway)
List: pgsql-hackers

Tree view

prepared statements don't log arguments?  (Palle Girgensohn, )
 Re: prepared statements don't log arguments?  (Greg Stark, )
  Re: prepared statements don't log arguments?  (Christopher Kings-Lynne, )
   Re: prepared statements don't log arguments?  (Neil Conway, )
    Re: prepared statements don't log arguments?  (Abhijit Menon-Sen, )
    Re: prepared statements don't log arguments?  (Alvaro Herrera, )
    Re: prepared statements don't log arguments?  (Oliver Jowett, )
     Re: prepared statements don't log arguments?  (Neil Conway, )
     Re: prepared statements don't log arguments?  (Tom Lane, )
  Re: prepared statements don't log arguments?  (Oliver Jowett, )
   Re: prepared statements don't log arguments?  (Palle Girgensohn, )
 Re: prepared statements don't log arguments?  (Simon Riggs, )
  Re: prepared statements don't log arguments?  (Palle Girgensohn, )
   Re: prepared statements don't log arguments?  (Simon Riggs, )
    Re: prepared statements don't log arguments?  (Oliver Jowett, )
     Re: prepared statements don't log arguments?  (Tom Lane, )
      Re: prepared statements don't log arguments?  (Simon Riggs, )
       Re: prepared statements don't log arguments?  (Oliver Jowett, )
        Re: prepared statements don't log arguments?  (Simon Riggs, )
         Re: prepared statements don't log arguments?  (Oliver Jowett, )

On Thu, Apr 07, 2005 at 12:14:19PM +1000, Neil Conway wrote:
> Christopher Kings-Lynne wrote:
> >I think he has a really excellent point.  It should log the parameters 
> >as well.
> 
> neilc=# prepare foo(int, int) as select $1 + $2;
> PREPARE
> neilc=# execute foo(5, 10);
> ...
> neilc=# execute foo(15, 20);
> ...
> 
> % tail /usr/local/pgsql/postmaster.log
> LOG:  statement: prepare foo(int, int) as select $1 + $2;
> LOG:  statement: execute foo(5, 10);
> LOG:  statement: execute foo(15, 20);

Yeah, but I think he mentioned JDBC which (I think) uses the low-level
protocol and probably doesn't log the parameters as well (I notice that
his example has INSERT as the query, not PREPARE nor EXECUTE.)

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"I call it GNU/Linux. Except the GNU/ is silent." (Ben Reiter)



pgsql-hackers by date:

From: Tom Lane
Date:
Subject: Re: prepared statements don't log arguments?
From: "Qingqing Zhou"
Date:
Subject: Re: Did this issue ever get resolved?