X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0AC2E9DCA83 for ; Thu, 2 Feb 2006 14:36:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51548-07 for ; Thu, 2 Feb 2006 14:36:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by postgresql.org (Postfix) with ESMTP id 880DD9DC9C9 for ; Thu, 2 Feb 2006 14:36:52 -0400 (AST) Received: from wired-106.internal.hcssystems.com (68.143.134.146.nw.nuvox.net [68.143.134.146]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id k12IuNn21848; Thu, 2 Feb 2006 12:56:23 -0600 Subject: Re: [BUGS] BUG #2171: Differences compiling plpgsql in From: Andrew Dunstan To: Bruce Momjian Cc: andrew5@ece.cmu.edu, PostgreSQL-patches In-Reply-To: <200602020448.k124mjG25834@candle.pha.pa.us> References: <200602020448.k124mjG25834@candle.pha.pa.us> Content-Type: text/plain Date: Thu, 02 Feb 2006 13:36:41 -0500 Message-Id: <1138905401.5342.15.camel@swithin> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.071 required=5 tests=[AWL=0.071] X-Spam-Score: 0.071 X-Spam-Level: X-Archive-Number: 200602/34 X-Sequence-Number: 18699 On Wed, 2006-02-01 at 23:48 -0500, Bruce Momjian wrote: > I have researched your report, and you are right, there are two ecpg > bugs here. First, dollar quoting uses single-quotes internally to do > the quoting, but it does not double any single-quotes in the > dollar-quoted string. > As a matter of curiosity, why does ecpg handle dollar quoting like that? psql, for example, happily just passes a dollar quoted string through to the backend, without any need to convert it to a conventionally quoted string. cheers andrew