Re: ecpg 'set' failure using host vars

Bosco Rama <[email protected]>
Newsgroups gmane.comp.db.postgresql.interfaces
Message-ID <[email protected]> 
Sorry about the 'false start' before. :-(

Tom Lane wrote:
> Michael Meskes <[email protected]> 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.

-- 
Sent via pgsql-interfaces mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.