From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | Vincent Chan <joy717(dot)xmu(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5939: About bytea |
Date: | 2011-04-01 03:49:20 |
Message-ID: | 4D954B40.2050702@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2011-04-01 04:56:29 | Re: BUG #5856: pg_attribute.attinhcount is not correct. |
Previous Message | Greg Stark | 2011-04-01 01:56:23 | Re: Postgres not using indexes |