Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7D2B46501A1 for ; Sat, 16 Aug 2008 14:17:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05012-06 for ; Sat, 16 Aug 2008 14:16:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tempest.mainecoon.com (tempest.mainecoon.com [69.12.217.123]) by postgresql.org (Postfix) with ESMTP id A8F63650020 for ; Sat, 16 Aug 2008 14:16:58 -0300 (ADT) Received: from [10.1.1.2] (fw.boscorama.com [75.101.8.88]) by tempest.mainecoon.com (Postfix) with ESMTPSA id BCEB36EA0A5 for ; Sat, 16 Aug 2008 10:16:56 -0700 (PDT) Message-ID: <48A70B88.4050800@boscorama.com> Date: Sat, 16 Aug 2008 10:16:56 -0700 From: Bosco Rama User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.16) Gecko/20080717 SeaMonkey/1.1.11 Mnenhy/0.7.4.0 MIME-Version: 1.0 CC: pgsql-interfaces@postgresql.org Subject: Re: ecpg 'set' failure using host vars References: <48A64DE5.4000906@boscorama.com> <20080816083156.GA26567@feivel.credativ.de> <14940.1218902460@sss.pgh.pa.us> In-Reply-To: <14940.1218902460@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.581 tagged_above=0 required=5 tests=MISSING_HEADERS=1.581 X-Spam-Level: * X-Archive-Number: 200808/9 X-Sequence-Number: 6784 Tom Lane wrote: > Michael Meskes writes: >> Without checking the sources it seems as if PQexecParams is not able to handle a parameter in a set command. Can anyone confirm this? > > The backend only supports parameters in plannable statements, ie > SELECT/INSERT/UPDATE/DELETE. (Possibly DECLARE CURSOR, I'm too > lazy to check.) > > regards, tom lane >