Postgres 9.0 and bytea?
Postgres 9.0 and bytea?
- Subject: Postgres 9.0 and bytea?
- From: Anjo Krank <email@hidden>
- Date: Thu, 6 Jan 2011 01:09:44 +0100
Hi,
is anyone here using PG with bytea columns?
I just updated a test db from 8.3 to 9.0 and am getting errors on received data - rs.getBytes(col) returns the bytes (49) for the characters of my PKs, not the bytes.
In the shell, it looks like this in 8.3:
gaia=# select length(pk_id) from age_group limit 1;
length
--------
24
(1 row)
gaia=# select pk_id from age_group limit 1;
pk_id
--------------------------------------------------------------------------------------
\000\000\300\250\214\007\000\000\226\036\021\000\000\000\000\3678\363!\221\333m#\003
(1 row)
for 9.0 it's like:
gaia=# select length(pk_id) from age_group limit 1;
length
--------
24
(1 row)
gaia=# select pk_id from age_group limit 1;
pk_id
--------------------------------------------------------------------------------------
\x0000c0a88c070000961e1100000000f738f32191db6d2303
(1 row)
Updating drivers to 9.0 didn't help so far, my guess is that there is a new setting. Is anyone familiar with PG and 9.0?
Cheers, Anjo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden