Re: ecpg 'set' failure using host vars

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ecpg 'set' failure using host vars
Date: 2008-08-20 16:45:53
Message-ID: 48AC4A41.40204@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2008-08-20 16:51:30 Re: ecpg 'set' failure using host vars
Previous Message Tom Lane 2008-08-20 16:16:52 Re: A smaller default postgresql.conf

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Meskes 2008-08-20 16:51:30 Re: ecpg 'set' failure using host vars
Previous Message Bosco Rama 2008-08-20 16:39:55 Re: schema name in the SQL statement.