Hi all, I resend this mail because I didn't have any answer; I still did'nt find any solution, the same line is ALWAYS failing although I see no error.
Of course, I can't post the dump 'cause it's over 200 Megs but if some one wants to make test (need to be postgres), I can arrange to put it on private ftp; I have actually 2 databases with the problem; running 7.3.4 pg_dump or 7.4.1 dosn't change the problem. Can some one help me please... -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------- Forwarded message ---------- Date: Fri, 9 Jan 2004 13:54:22 +0100 (MET) From: [EMAIL PROTECTED] To: pgsql-hackers list <[EMAIL PROTECTED]> Subject: Strand COPY from problem Hi every one and Happy new year (this is my first post since 2004) I wanted to upgrade my system from 7.3.4 to 7.4. and fell on this: One of the databases I host doesn't load correctly. Let me explain: I first pg_dumpall (with the 7.4.1 version) using the 7.3.4 port; that works fine. The psql -f all.sql template1 on the 741 version to recreate every thing. 2 copy don't work. those tables both contain a large text column with text containing lots of \r\n ' " . What's stange is that copy from stdin; obviously don't work but if I copy table to '/tmp/xxx.dat' in 7.3.4 and copy table from 'xxx.dat' in 7.4.1, it works fine... Could there but something wrong with from stdin? TIA for your help... -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
