"Petro Meier" <Petro85(at)gmx(dot)de> writes:
> INSERT INTO "testtable" ("ID", "BinaryContents") values (1,
> E'\xea2abd8ef3');
> returns "invalid byte sequence".
> '\xea2abd8ef3' is the string delivered by the PG 9.1 Beta3 server
> when calling PQescapeByteaConn(). It cannot be further processed by the
> server itself afterwards! There is a leading '\' missing.
No, there isn't. What you are doing wrong is prepending an E to the
literal. You should not be doing that, neither in 9.1 nor any previous
version.
regards, tom lane