Re: COPY fails on 8.1 with invalid byte sequences in text - Mailing list pgsql-bugs

From Tom Lane
Subject Re: COPY fails on 8.1 with invalid byte sequences in text
Date
Msg-id 12032.1162354733@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY fails on 8.1 with invalid byte sequences in text  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: COPY fails on 8.1 with invalid byte sequences in text
Re: COPY fails on 8.1 with invalid byte sequences in text
List pgsql-bugs
Jeff Davis <pgsql@j-davis.com> writes:
> Is this not a bug?

I don't actually see that it is.  The documentation is perfectly clear
on the point:

    (It is your responsibility that the byte sequences you create
    are valid characters in the server character set encoding.)

(This is in 4.1.2.1. String Constants)  If you don't want to deal with
this, don't use octal escapes to construct multibyte characters.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2727: pg_restore error on BLOB COMMENTS
Next
From: "Yee"
Date:
Subject: BUG #2728: Core dump while pgdump DB