From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: /* */ comments showing up in pg_stat_activity
Date: Sat, 26 Apr 2003 10:18:43 +0530
User-Agent: KMail/1.5
Cc: pgsql-sql@postgresql.org
References: <200304251617.h3PGHWZ24565@candle.pha.pa.us>
	<3EA9F35A.848AB5D1@Yahoo.com> <11772.1051326326@sss.pgh.pa.us>
In-Reply-To: <11772.1051326326@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200304261018.43661.mallah@trade-india.com>

On Saturday 26 Apr 2003 8:35 am, Tom Lane wrote:
> Jan Wieck <JanWieck@Yahoo.com> writes:
> > The question back is from where does such a query with a comment come?
> > If it is a standard client like psql, it could happen someday that this
> > client does some filtering.


Yes its thru psql only , i run a SQL batch using
psql -e -h db -f batch.sql

In case future version of psql strips them it would
still be nice if libpq continue supporting it 
i feel it would be a nice feature for keeping track of
queries.


Regds
Mallah.


>
> psql already does strip comments (and always has, AFAIK).
>
> > If you're using libpq or another API that is
> > basically a libpq wrapper, you're pretty safe.
>
> Agreed, I doubt we'd ever bother to put comment-stripping logic in libpq.
>
> 			regards, tom lane

-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.