Skip site navigation (1) Skip section navigation (2)

Re: BUG #4550: ecpg problem with copy command and hostvar

From: "Clemens A(dot) Fischer" <clemens(dot)fischer(at)mbs-software(dot)de>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: Clemens Fischer <cfi(at)mbs-software(dot)de>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4550: ecpg problem with copy command and hostvar
Date: 2008-11-26 14:02:24
Message-ID: 1227708144.3280.12.camel@linux2-cfi.dhcp.internal (view raw or flat)
Thread:
Lists: pgsql-bugs
Hallo Michael,

Am Mittwoch, den 26.11.2008, 14:49 +0100 schrieb Michael Meskes:
> On Tue, Nov 25, 2008 at 12:28:38PM +0000, Clemens Fischer wrote:
> > The copy command can't be used with a hostvar.
> 
> This is essentially the answer. The major difference between the ecpg version
> of PostgreSQL 8.2 and 8.3 is that the 8.3 version uses the backend supplied
> prepare/execute facility instead of just simulating this feature. Part of this
> change was to change the variable handling and no longer construct strings on
> the client side but pass the variables to the backend directly. But there is no
> way to pass a variable filename for the copy command AFAIK. Or in other words,
> the old versions had a bug in that they accepted a variable there. 
> 
> Can you use EXECUTE and put the whole statement into a variable instead?
I switched to EXECUTE yesterday. It works.
> 
> Michael
Thank you

Clemens



In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-11-26 14:38:04
Subject: Re: BUG #4549: ecpg produces code that don't compile
Previous:From: Clemens A. FischerDate: 2008-11-26 13:56:33
Subject: Re: BUG #4549: ecpg produces code that don't compile

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group