| 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: | Whole Thread | Raw Message | 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 |