X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7AE964762F1
	for <pgsql-sql@postgresql.org>; Fri, 25 Apr 2003 23:05:23 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id AE92A4762CF
	for <pgsql-sql@postgresql.org>; Fri, 25 Apr 2003 23:05:22 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3Q35RU6011773;
	Fri, 25 Apr 2003 23:05:27 -0400 (EDT)
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>,
	Rajesh Kumar Mallah <mallah@trade-india.com>, pgsql-sql@postgresql.org
Subject: Re: /* */ comments showing up in pg_stat_activity 
In-reply-to: <3EA9F35A.848AB5D1@Yahoo.com> 
References: <200304251617.h3PGHWZ24565@candle.pha.pa.us>
	<3EA9F35A.848AB5D1@Yahoo.com>
Comments: In-reply-to Jan Wieck <JanWieck@Yahoo.com>
	message dated "Fri, 25 Apr 2003 22:47:54 -0400"
Date: Fri, 25 Apr 2003 23:05:26 -0400
Message-ID: <11772.1051326326@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-32.3 required=5.0
	tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/389
X-Sequence-Number: 13090

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.

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