X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3FFCCD8F9F for ; Wed, 14 Sep 2005 23:49:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22456-08 for ; Thu, 15 Sep 2005 02:49:47 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D149FD8F80 for ; Wed, 14 Sep 2005 23:49:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8F2nr2l009316; Wed, 14 Sep 2005 22:49:53 -0400 (EDT) To: "Greg Sabino Mullane" Cc: pgsql-interfaces@postgresql.org, Sean Davis Subject: Re: Beta of DBD::Pg 1.44 available In-reply-to: <35dd10e25f1ee6e3f027c9c73d0b0b8d@biglumber.com> References: <35dd10e25f1ee6e3f027c9c73d0b0b8d@biglumber.com> Comments: In-reply-to "Greg Sabino Mullane" message dated "Wed, 14 Sep 2005 23:52:57 -0000" Date: Wed, 14 Sep 2005 22:49:53 -0400 Message-ID: <9315.1126752593@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/23 X-Sequence-Number: 5746 "Greg Sabino Mullane" writes: >> Thanks for doing all of this. I will give it a whirl. Just a quick >> question on the point directly above: does this imply that explain and >> explain analyze are excluded from placeholder parsing? The existing approach for that is PREPARE foo(parameter types) AS SELECT ... EXPLAIN [ANALYZE] EXECUTE foo(parameter values) > ... A third (and probably best) option is to make the parser > inside of DBD::Pg recognize dollar-quoting. I think you need to do that, independently of anything else ... regards, tom lane