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

Re: ecpg 'set' failure using host vars

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Bosco Rama <postgres(at)boscorama(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ecpg 'set' failure using host vars
Date: 2008-08-19 10:31:18
Message-ID: 20080819103118.GA23760@feivel.credativ.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
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.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

Attachment: ecpg_set.diff
Description: text/x-diff (558 bytes)

In response to

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2008-08-19 10:38:10
Subject: Re: Patch: plan invalidation vs stored procedures
Previous:From: Hannu KrosingDate: 2008-08-19 10:22:49
Subject: Re: Patch: plan invalidation vs stored procedures

pgsql-interfaces by date

Next:From: Masis, Alexander (US SSA)Date: 2008-08-19 22:43:27
Subject: schema name in the SQL statement.
Previous:From: Michael MeskesDate: 2008-08-18 14:58:21
Subject: Re: ecpg 'set' failure using host vars

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