pg_restore 7.4 from 7.2.1 - Mailing list pgsql-admin

From Uwe Maiwald
Subject pg_restore 7.4 from 7.2.1
Date
Msg-id 5.2.1.1.0.20031128133735.00a7ee60@mx0.kiss-net.de
Whole thread Raw
List pgsql-admin
Hi,

i get errors restoring a 7.2.1 dump into 7.4

the commands were

Version 7.2.1:  pg_dump -Ft -b dbname > filename
Version 7.4  pg_restore -d dbname filename

pg_restore: ERROR:  literal carriage return found in data
HINT:  Use "\r" to represent carriage return.
CONTEXT:  COPY Aktionspartner, line 2: "1       Sparkasse
Pfullendorf-Meßkirch  Bahnhofstraße   88630   Pfullendorf 07552 /
263-0    User Name   6905162..."
pg_restore: [archiver (db)] error returned by PQendcopy


i read in the mailing list, that others have the same problem. I know, that
COPY no longer supports literal carriage-returns in 7.4
So i would like to know if this problem is by design (of pg_restore), or if
it will be solved in a future release.

thanks,

Uwe


pgsql-admin by date:

Previous
From: omkar prabhu
Date:
Subject: PGDUMP BLOB PROBLEM
Next
From: Palle Girgensohn
Date:
Subject: server & client using different version, OK?