Re: [GENERAL] postgresql-9.1.1 PQescapeByteaConn() generating incorrectly quoted output.

2011-11-05 Thread Graham Murray
On Wed, 2011-11-02 at 18:21 +, Tom Lane wrote: > Graham Murray writes: > > Since upgrading test systems to postgresql 9.1, I am seeing some > inserts > > to bytea fields giving errors such as "ERROR: invalid byte sequence > for > > encoding "UTF8":

[GENERAL] postgresql-9.1.1 PQescapeByteaConn() generating incorrectly quoted output.

2011-11-02 Thread Graham Murray
Since upgrading test systems to postgresql 9.1, I am seeing some inserts to bytea fields giving errors such as "ERROR: invalid byte sequence for encoding "UTF8": 0xf9" Where the insert is from a C program using libpq and is of the form "insert into xxx values(E'%s')" where the value is the return