From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Strange COPY from problem (resent) |
Date: | 2004-01-14 18:53:00 |
Message-ID: | Pine.UW2.4.53.0401141948280.26391@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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...
--
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-14 19:26:26 | Re: DBT-2 pulls PostgreSQL from CVS for STP |
Previous Message | markw | 2004-01-14 16:58:08 | DBT-2 pulls PostgreSQL from CVS for STP |