BUG #1619: ECPG allows definition of binary cursors but can't handle the result

From: "" <matthias(dot)schinacher(at)gmx(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1619: ECPG allows definition of binary cursors but can't handle the result
Date: 2005-04-22 14:17:10
Message-ID: 20050422141710.611A1F144B@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1619
Logged by:
Email address: matthias(dot)schinacher(at)gmx(dot)de
PostgreSQL version: 8.0.1
Operating system: Suse Linux 9.1 (x86)
Description: ECPG allows definition of binary cursors but can't
handle the result
Details:

I'm not certain this is a "bug", but seems a un-documented restriction of
ECPG.

one can use a binary cursor definition in a ECPG program, but there is no
(or no documented) way of fetching the data into host variables, as this
allways assumes a text representation.

thus for example, when fetching an integer type field from a binary cursor
into a 'int', the applied conversion implicitly assumes an empty string if
the first byte retrieved is '\0' and will assign a zero value to the 'int',
even if the binary representation received from the server has a non zero
interpretation (.e.g. like receiving the four bytes 00,FF,FF and FF).

maybe it would be a good idea to explicitly mention this in the manual as a
restriction and/or to generate
an error when ecpg encounters a binary cursor?

Browse pgsql-bugs by date

  From Date Subject
Next Message Nahuel Greco 2005-04-22 19:39:33 BUG #1620: triggers breaks with alter table (at least with plpythonu)
Previous Message Kris Jurka 2005-04-22 13:54:32 Re: BUG #1611: reading a date-field by "ResultSet.getTimestamp()"