ODBC-link returns zero rows, allthough query should return 3 rows - Mailing list pgsql-sql

Hi,

We are trying to make use of module ODBC-link. We follow the
instructions as read in README.TXT, including the given examples.
Connecting to an external Oracle database and running a query using unixODBC is successful:
===========================================================================================
$ isql -v ONT_KIS sbm_beheer bioinf
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from mytable;
+------------------+---------------------------------------------------+------------------+
| ID               | T                                                 | D                |
+------------------+---------------------------------------------------+------------------+
| 1                | FIRST TEXT                                        | 1.3              |
| 2                | SECOND TEXT                                       | 4                |
| 3                | THIRD TEXT                                        | 4                |
+------------------+---------------------------------------------------+------------------+
SQLRowCount returns -1
3 rows fetched
===========================================================================================

Now trying the same, using ODBClink result in zero rows:
===========================================================================================
$ psql oratest psql (8.4.3)
Type "help" for help.

oratest=# select odbclink.connect('ONT_KIS', 'sbm_beheer', 'bioinf');            connect
---------      1
(1 row)

oratest=# select * FROM odbclink.query(1, 'SELECT id, t, d FROM mytable WHERE id=2') as result(id float, t text, d
float);id| t | d 
----+---+---
(0 rows)
===========================================================================================

Unfortunately the developers of the ODBClink do not answer my mails, so I ask you if someone out there has any clue. It
willalso be appreciated if anyone can point me to a more appropriate mailing list. 

We're running PostgreSQL 8.4.3, ODBC-link 1.0.

TIA,

Reinier Suurenbroek


Keygene N.V.
P.O. Box 216
6700 AE Wageningen
The Netherlands
Tel. (+31) 317 46 68 66
Fax. (+31) 317 42 49 39
Web: http://www.keygene.com/

The information contained in this message, and attachments if any, may be privileged and/or confidential and is
intendedto be received only by persons entitled to receive such information. Use of any part of this message and/or its
attachmentsif any, in any other way than as explicitly stated by the sender is strictly prohibited. Should you receive
thismessage unintentionally please notify the sender immediately, and delete it together with all attachments, if any.
Thankyou. 
The transmission of messages and/or information via the Internet is not secured and may be intercepted by third
parties.KeyGene assumes no liability for any damage caused by any unintentional disclosure and/or use of the content of
thismessage and attachments if any.