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...

--
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)