Dear list,
I have made some progress about the current state of the ODBC drivers.
I have tried three ODBC drivers :
The original ODBC river, as compiled by Oliver Elphick in the Debian
7.1beta4 packages : this one is utterly broken : trying to use it leads
to nothing : no activity is loged neither in syslog nor in postgres.log
with -d2. Nick Gorham says it's because the driver and the driver
manager wait mutually for each other, IIRC.
The same driver patched (how ?) by Nick Gorham has some basic
functionality : it can query the DB in arbitrary ways and is able to do
other basic things. However, it has other problems. It displays only
tables, not views, and has some serious limitations on system tables.
Nick Gorham's unixODBC driver. This ione has only basic functionality :
it can connect and query the backend, but only with a hand-crafted
query. No way to get the list of tables, nor metadata.
In the first case, I can do nothing : I'm reluctant to try to rebuild
the Debian packages from source (I don't kniow how to do this from the
sources and Oliver's patches). It follows that I can't do that for the
second either.
However, the problems exhibited by the second and third drivers are of
the same nature : the SQL queries sent by them to get thje metadata are
no longer valid for 7.1, since the system tables have undergo a lot of
changes.
I will try to fix the third and publish my result and changes, hoping to
see them ported on the first one.
Any thoughs ?
And, BTW, where can I find the docs of the 7.0 system tables ? I know
where the 7.1 docs are ...
Sincerely yours,
Emmanuel Charpentier