Re: [opendbx] Postgresql + bytea data type

[Norbert S. <no...@li...>]

Hi Guille

> I was trying to query a *bytea* from a postgresql database with opendbx and
> I'm getting a UNKNOWN type from it :(.  However, the value retrieved looks
> ok.
>
> I was looking at
> http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes but there
> is no mention of the *bytea*.
>
> Are you planning to support bytea?

Bytea data is something PostgreSQL specific and it can't be mapped to 
any standard ANSI SQL data type so no, this doesn't seem to be possible. 
There's a patch from Zhao Tongyi (from 2011-07-11) to add support for 
encoding/decoding but the pgsql backend but the approach is not optimal. 
It would be better to add another interface to the library that returns 
the bare connection handle so specific things only available for the 
specific backend would be possible to do. If someone would be able to 
provide a patch for this against 1.5.x, I would be happy to integrate it 
into SVN.


Norbert