Re: ecpg 'set' failure using host vars
Bosco Rama <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
Hi Michael, Michael Meskes wrote: > On Fri, Aug 15, 2008 at 08:47:49PM -0700, Bosco Rama wrote: >> exec sql char *sm; >> ... >> sm = "myschema"; // This may not always be constant >> ... >> exec sql set search_path to :sm; > > Could you please try the attached patch and tell me whether it works > for you? I will then check this in into 8.3 so that the next stable > release works again as it should. Thanks for working on this. Unfortunately I'm just an applications person and our systems use the FC9 distribution's pre-compiled packages only (it's a sysadmin thing). I asked them about it and they said (and I quote): "When it becomes part of the FC9 distribution they will 'consider' (my emphasis) upgrading the packages." *sigh* I really appreciate the effort and the fix but for now I have to be satisfied with the work-around you guys suggested previously. :-( Bosco. -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces