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