Re: bytea type shows different size on FreeBSD - Mailing list psycopg

From Daniele Varrazzo
Subject Re: bytea type shows different size on FreeBSD
Date
Msg-id AANLkTik6_v3V0m443XXLNFYNSnRmCjh3ph6DN65JqM_Z@mail.gmail.com
Whole thread Raw
In response to bytea type shows different size on FreeBSD  (Landreville <landreville@deadtreepages.com>)
List psycopg
On Sat, Feb 12, 2011 at 12:48 AM, Landreville
<landreville@deadtreepages.com> wrote:
> I'm using psycopg-2.4 beta1 on FreeBSD and it is giving me a size that is
> twice the actual size for the bytea field on a table. In OSX and Linux using
> the same psycopg2 version the size is listed as 6151 (which is correct)
> while under FreeBSD it lists the size as 12303.
>
> Has anyone else encountered this, or is there some way I can do further
> debugging to determine the cause?

Do you have a sample of what you receive? E.g. the first 100 bytes
with a "print repr(cur.fetchone()[0][:100])"?

Could you be in the problematic situation of a PostgreSQL 9.0 with the
previous version on the client? The problems is detailed in a faq at
<http://initd.org/psycopg/docs/faq.html#problems-with-type-conversions>,
see "Transferring binary data from PostgreSQL 9.0 doesn’t work".

Regards,

-- Daniele

psycopg by date:

Previous
From: Landreville
Date:
Subject: bytea type shows different size on FreeBSD
Next
From: Daniele Varrazzo
Date:
Subject: beta 2 release for win testing?