Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C891A6502D7 for ; Sat, 16 Aug 2008 14:20:46 -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 10059-04 for ; Sat, 16 Aug 2008 14:20:42 -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 E58A66502D0 for ; Sat, 16 Aug 2008 14:20:43 -0300 (ADT) Received: from [10.1.1.2] (fw.boscorama.com [75.101.8.88]) by tempest.mainecoon.com (Postfix) with ESMTPSA id 775B06EA09F for ; Sat, 16 Aug 2008 10:20:42 -0700 (PDT) Message-ID: <48A70C6A.6080107@boscorama.com> Date: Sat, 16 Aug 2008 10:20:42 -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 To: 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=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/10 X-Sequence-Number: 6785 Sorry about the 'false start' before. :-( 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.) Thanks for the hint guys. I used a prepare/execute pair instead and it worked a treat. More cumbersome but it gets the job done. Thanks again. Bosco.