Thanks, Daryl, that works. Best regards, Marina.
--------------------------------------------------------- Marina Olhovsky Software Engineer, Pawson Laboratory Mount Sinai Hospital 600 University Avenue, Room 1060 Toronto, Ontario, M5G 1X5 [EMAIL PROTECTED] --------------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] on behalf of Daryl Tester Sent: Wed 1/24/2007 7:56 PM To: PyGreSQL Development; [email protected] Subject: Re: [PyGreSQL] Incomplete COPY from file Marina Olhovsky wrote: > for i in my_ids: > outfile.write(`i[0]` + '\n') You should close, or at least flush the file before executing - > q2 = "COPY tbl_2(new_id) FROM '" + fname + "'" > db.query(q2) Regards, Daryl Tester _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
<<winmail.dat>>
_______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
