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 libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
