Re: /* */ comments showing up in pg_stat_activity - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Re: /* */ comments showing up in pg_stat_activity
Date
Msg-id 200304261018.43661.mallah@trade-india.com
Whole thread Raw
In response to Re: /* */ comments showing up in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: /* */ comments showing up in pg_stat_activity  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Statement triggers 7.4 NEW/OLD
Next
From: Ian Barwick
Date:
Subject: Re: sorting chinese characters