Re: ecpg 'set' failure using host vars - Mailing list pgsql-interfaces

From Bosco Rama
Subject Re: ecpg 'set' failure using host vars
Date
Msg-id 48AC4A41.40204@boscorama.com
Whole thread Raw
In response to Re: ecpg 'set' failure using host vars  (Michael Meskes <meskes@postgresql.org>)
Responses Re: ecpg 'set' failure using host vars
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: Bosco Rama
Date:
Subject: Re: schema name in the SQL statement.
Next
From: Michael Meskes
Date:
Subject: Re: ecpg 'set' failure using host vars