From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200304282219.h3SMJOF20006@candle.pha.pa.us>
Subject: Re: /* */ comments showing up in pg_stat_activity
In-Reply-To: <Pine.LNX.4.33.0304262157100.696-100000@localhost.localdomain>
To: Rajesh Kumar Mallah <rmallah@trade-india.com>
Date: Mon, 28 Apr 2003 18:19:23 -0400 (EDT)
Cc: Rajesh Kumar Mallah <mallah@trade-india.com>,
	Tom Lane <tgl@sss.pgh.pa.us>, pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Rajesh Kumar Mallah wrote:
> But if i were to use DBD::Perl (which probably uses libpq)
> is it safe to pass query indentifier in comments which u 
> said are not stripped by psql eg
> /* AppName: Xyzt */ Select foo from bar where cw='t' ;
> for years to come ?
> 
> why i ask is that i was always curious of the slow 
> long running queries in pg_stat_activity and not able
> to figure out the source had frustrated me , now
> this method if it works seems to me as a viable solution.

I think you have to look try perl to see how it handles it, but I think
it just passes the query whole, so all the comments should pass
themselves to the backend.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073