Re: /* */ comments showing up in pg_stat_activity

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: /* */ comments showing up in pg_stat_activity
Дата
Msg-id 200304261018.43661.mallah@trade-india.com
обсуждение исходный текст
Ответ на Re: /* */ comments showing up in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: /* */ comments showing up in pg_stat_activity  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Statement triggers 7.4 NEW/OLD
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: sorting chinese characters