[PostgreSQL-Hackers] Re: [INTERFACES] ecpg 'set' failure using host vars

[PostgreSQL-Hackers] Re: [INTERFACES] ecpg 'set' failure using host vars

	Michael Meskes
	Aug 16, 2008 at 8:31 am

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: [email protected]
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

Search Discussions

1 response
Oldest
Nested

Tom Lane The backend only supports parameters in plannable statements, ie SELECT/INSERT/UPDATE/DELETE. (Possibly DECLARE CURSOR, I'm too lazy to check.) regards, tom lane

Tom Lane at Aug 16, 2008 at 4:01 pm ⇧

Michael Meskes writes:
Without checking the sources it seems as if PQexecParams is not able to handle a parameter in a set command. Can anyone confirm this?
The backend only supports parameters in plannable statements, ie
SELECT/INSERT/UPDATE/DELETE. (Possibly DECLARE CURSOR, I'm too
lazy to check.)

regards, tom lane

reply | permalink

Related Discussions

Discussion Navigation

view	thread \| post

Discussion Overview

group	pgsql-hackers @
categories	postgresql
posted	Aug 16, '08 at 8:31a
active	Aug 16, '08 at 4:01p
posts	2
users	2
website	postgresql.org...
irc	#postgresql

responses	expanded	Hotkey: s
font	variable	Hotkey: f
user style	avatars	Hotkey: a

[PostgreSQL-Hackers] Re: [INTERFACES] ecpg 'set' failure using host vars

Search Discussions

Related Discussions

2 users in discussion