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.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2008-11-26 14:38:04|
|Subject: Re: BUG #4549: ecpg produces code that don't compile |
|Previous:||From: Clemens A. Fischer||Date: 2008-11-26 13:56:33|
|Subject: Re: BUG #4549: ecpg produces code that don't compile|