Re: ecpg 'set' failure using host vars
Michael Meskes <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
>>> 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: [email protected] Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL! -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces