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

From Denis BUCHER
Subject Re: Strange "bug" in dump ?
Date
Msg-id 4B111DA0.5060206@hsolutions.ch
Whole thread Raw
In response to Re: Strange "bug" in dump ?  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
Responses Re: Strange "bug" in dump ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Rikard Bosnjakovic a écrit :
>> 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',
>
> Sounds like escape quoting to me. You can read about it at
> <http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html>.
> I'm not sure how good 7.4.6 is at unicode-quoting, but I surmise this
> could be the source of the error that it is not able to handle the
> correct string quoting.

Oh yes, great, then it's not a bug but "String Constants with C-Style
Escapes" !

But this seems to be a 8.4 feature not supported by 7.4.6 ?
If you have an idea on how to have 7.4.6 accept it...

Thanks a lot for your help :-)

Denis

pgsql-general by date:

Previous
From: Rikard Bosnjakovic
Date:
Subject: Re: Strange "bug" in dump ?
Next
From: Roger Leigh
Date:
Subject: Re: Locale query