Jeff Davis <pgsql(at)j-davis(dot)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