Message-ID: <48AC4A41.40204@boscorama.com>
Date: Wed, 20 Aug 2008 09:45:53 -0700
From: Bosco Rama <postgres@boscorama.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.8.1.16) Gecko/20080717 SeaMonkey/1.1.11 Mnenhy/0.7.4.0
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: ecpg 'set' failure using host vars
References: <48A64DE5.4000906@boscorama.com>
	<20080819103118.GA23760@feivel.credativ.de>
In-Reply-To: <20080819103118.GA23760@feivel.credativ.de>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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.