Re: PQescapeByteaConn and the new hex encoding

Il 25/12/2009 18:54, Tom Lane ha scritto:
> Matteo Beccati<php@beccati.com>  writes:
>> However, before taking a look at the actual code and understanding its
>> behaviour, I tried using "SET bytea_output = 'escape'" and I was
>> expecting PQescapeByteaConn to honour it.
>
> Why?  PQescapeByteaConn's charter is to produce something that will work
> on the given connection, no more and no less.

Makes complete sense :)

I was just trying to find a way to get the PHP function pg_escape_bytea 
(which uses PQescapeByteaConn if available) to generate a backwards 
compatible escaped string. It's probably just a corner case though and 
it can be dealt with at the client side, if necessary.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/