Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

pg_restore 7.4 from 7.2.1



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


---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings




<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.