Strange "bug" in dump ? - Mailing list pgsql-general

From Denis BUCHER
Subject Strange "bug" in dump ?
Date
Msg-id 4B111085.6020503@hsolutions.ch
Whole thread Raw
Responses Re: Strange "bug" in dump ?  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
List pgsql-general
Dear all,

When doing a dump of a 8.1.17, database (that I have to reimport daily
into a 7.4.6), I have a strange bugs with accents...

First point, I had to add --insert.

But there is still a problem with accents.

If I say nothing the dump is utf8, or I can add -E=latin1.

But in both cases it fails, and there is a very strange error !
There is a "E" before the street field !

This is an extract of the dump :

'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5',

311 is shown instead of accent

Does someone knows what could be this problem ?

Denis

pgsql-general by date:

Previous
From: Eduardo Piombino
Date:
Subject: Date with time zone
Next
From: Rikard Bosnjakovic
Date:
Subject: Re: Strange "bug" in dump ?