Re: BUG #5939: About bytea

On 22/03/2011 2:34 PM, Vincent Chan wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5939
> Logged by: Vincent Chan
> Email address: joy717(dot)xmu(at)gmail(dot)com
> PostgreSQL version: 9.0
> Operating system: Win7 x64
> Description: About bytea
> Details:
>
> when saving a bytes array,
> for example a bytes array which length is 2,
> but after saving,
> it's length will be change to 3.
> but in postgres 8.4, the array length is still 2.
> Is this a bug?

I'd say you're using a client driver version that doesn't understand
hex-encoded escapes. Try setting bytea_output to 'escape' instead of 'hex'.

It'd help if you provided even some minimal information like code
samples, the language you're using, the version of the access driver
(npgsql/pgodbc/libpq/psycopg/php-pgsql/etc) you're using, and other
basic details.

Please read the PostgreSQL 9.0 release notes:
http://www.postgresql.org/docs/9.0/static/release-9-0.html
and the documentation on bytea:
http://www.postgresql.org/docs/9.0/static/datatype-binary.html

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/