From: Michael Meskes <meskes@postgresql.org>
To: Bosco Rama <postgres@boscorama.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ecpg 'set' failure using host vars
Date: Mon, 18 Aug 2008 16:58:21 +0200
Message-ID: <20080818145821.GA5062@feivel.credativ.de> (raw)
In-Reply-To: <48A70C6A.6080107@boscorama.com>
References: <48A64DE5.4000906@boscorama.com>
<20080816083156.GA26567@feivel.credativ.de>
<14940.1218902460@sss.pgh.pa.us>
<48A70C6A.6080107@boscorama.com>
>>> 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.
I will fix this as soon as my time permits. There is logic there in ecpg to
handle parameters on the client side.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, postgres@boscorama.com
Subject: Re: ecpg 'set' failure using host vars
In-Reply-To: <20080818145821.GA5062@feivel.credativ.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox