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....@gmail.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/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs