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.
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 |
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. |