From: | Michael Meskes <meskes(at)postgresql(dot)org> |
---|---|
To: | Bosco Rama <postgres(at)boscorama(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: ecpg 'set' failure using host vars |
Date: | 2008-08-16 08:31:56 |
Message-ID: | 20080816083156.GA26567@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:
> [22245]: ecpg_execute line 13256: QUERY: set search_path to $1 with 1 parameter on connection ecpgconn
> [22245]: ecpg_execute line 13256: using PQexecParams
> [22245]: free_params line 13256: parameter 1 = myschema
> [22245]: ecpg_check_PQresult line 13256: Error: ERROR: syntax error at or near "$1"
> LINE 1: set search_path to $1
Without checking the sources it seems as if PQexecParams is not able to handle a parameter in a set command. Can anyone confirm this?
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-08-16 12:45:10 | [Fwd: [COMMITTERS] pgsql: probes.h is generated from probes.d, not pg_trace.d.] |
Previous Message | Pavel Stehule | 2008-08-16 06:44:15 | Re: proposal sql: labeled function params |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-16 16:01:00 | Re: ecpg 'set' failure using host vars |
Previous Message | Bosco Rama | 2008-08-16 03:47:49 | ecpg 'set' failure using host vars |