Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group