Re: [opendbx] Postgresql + bytea data type

[Guillermo P. <gui...@gm...>]

Hmm, I supposed that! :P

As soon as we are done with the mayor taks of DBXTalk, we will give you a
hand in opendbx ;).

Thanks!!
Guille

On Thu, Sep 22, 2011 at 3:10 AM, Norbert Sendetzky <no...@li...
> wrote:

> 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
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>