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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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 Content-Type Size
ecpg_set.diff text/x-diff 558 bytes

In response to

Responses

Browse pgsql-hackers by date

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

Browse pgsql-interfaces by date

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