From: Michael Meskes <meskes@postgresql.org>
To: Bosco Rama <postgres@boscorama.com>
Cc: pgsql-interfaces@postgresql.org, PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Subject: Re: ecpg 'set' failure using host vars
Date: Sat, 16 Aug 2008 10:31:56 +0200
Message-ID: <20080816083156.GA26567@feivel.credativ.de> (raw)
In-Reply-To: <48A64DE5.4000906@boscorama.com>
References: <48A64DE5.4000906@boscorama.com>
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@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, postgres@boscorama.com, pgsql-hackers@postgresql.org
Subject: Re: ecpg 'set' failure using host vars
In-Reply-To: <20080816083156.GA26567@feivel.credativ.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox