Re: /* */ comments showing up in pg_stat_activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: /* */ comments showing up in pg_stat_activity
Date: 2003-04-26 03:05:26
Message-ID: 11772.1051326326@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jan Wieck <JanWieck(at)Yahoo(dot)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.

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-04-26 04:20:01 Re: Statement triggers 7.4 NEW/OLD
Previous Message Jan Wieck 2003-04-26 02:47:54 Re: /* */ comments showing up in pg_stat_activity