[wy copy dont't work with params]

Started by R.Tichyalmost 24 years ago2 messagesgeneral
Jump to latest
#1R.Tichy
r.tichy@sew-eurodrive.at

subscribe-nomail

Hallo, erverybody !

I am working with Postgresql 7.2 on cygwin !

I have this problem inside from Database with functions and inside from
JDBC....

A Example :

create or replace function copy_data (varchar,varchar) returns varchar
as '
declare
aurl ALIAS FOR $1;
adelim ALIAS FOR $2;
begin

-- nice its work very fine with static param ...
copy transimport from ''/home/usrer/imports/trans.txt'';

-- where default \t is fieldseparator don't work with params wy ?
copy transimport from aurl;

--very very cosmic not for use in copy
--aurl := ''''''/home/user/imports/trans.txt'''''';
--raise notice ''killer: %'',aurl;

return ''ok-master'';

end;
' language 'plpgsql';

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: R.Tichy (#1)
Re:

"Dorward Villaruz" <dorwardv@ntsp.nec.co.jp> writes:

is this a postgres error?, if so how can i solve this problem?

DEBUG: pq_recvbuf: recv() failed: Connection reset by peer

Looks to me like your client crashed.

regards, tom lane