Strand COPY from problem - Mailing list pgsql-hackers

From ohp@pyrenet.fr
Subject Strand COPY from problem
Date
Msg-id Pine.UW2.4.53.0401091337120.13635@server.pyrenet.fr
Whole thread Raw
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: Tommi Maekitalo
Date:
Subject: Re: psql \d option list overloaded
Next
From: Andrew Dunstan
Date:
Subject: Re: psql \d option list overloaded