Re: Strange COPY from problem (resent)

The problem has been solved by Tom Lane et was NOT a postgresql problem...
I'm ashamed to say so :à)

Regards
On Mon, 19 Jan 2004, Robert Treat wrote:

> Date: Mon, 19 Jan 2004 13:29:19 -0500
> From: Robert Treat <xzilla@users.sourceforge.net>
> To: ohp@pyrenet.fr, pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] 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@pyrenet.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@pyrenet.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@pyrenet.fr
> > To: pgsql-hackers list <pgsql-hackers@postgresql.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...
>
>

-- 
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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)