From: Bosco Rama <postgres@boscorama.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: ecpg 'set' failure using host vars
Date: Wed, 20 Aug 2008 09:45:53 -0700
Message-ID: <48AC4A41.40204@boscorama.com> (raw)
In-Reply-To: <20080819103118.GA23760@feivel.credativ.de>
References: <48A64DE5.4000906@boscorama.com>
<20080819103118.GA23760@feivel.credativ.de>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: postgres@boscorama.com
Subject: Re: ecpg 'set' failure using host vars
In-Reply-To: <48AC4A41.40204@boscorama.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox