Thread: Strange COPY from problem (resent)
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)
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...
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
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)