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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
