Re: Strange COPY from problem (resent)

It's not ideal, but can you dump those tables using INSERT commands and load
them into your database?

Robert Treat

On Wednesday 14 January 2004 13:53, ohp(at)pyrenet(dot)fr wrote:
> 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: ohp(at)pyrenet(dot)fr
> ---------------------------------------------------------------------------
>--- 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: ohp(at)pyrenet(dot)fr
> To: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> 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...

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL