Thread: pg_restore 7.4 from 7.2.1

pg_restore 7.4 from 7.2.1

From
Uwe Maiwald
Date:
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