Thread: Current ODBC driver(s) problems with 7.1

Current ODBC driver(s) problems with 7.1

From
Emmanuel Charpentier
Date:
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


Re: Current ODBC driver(s) problems with 7.1

From
"Oliver Elphick"
Date:
Emmanuel Charpentier wrote: >I have tried three ODBC drivers : > >The original ODBC river, as compiled by Oliver
Elphickin the Debian >7.1beta4 packages : this one is utterly broken : trying to use it leads >to nothing : no activity
isloged neither in syslog nor in postgres.log >with -d2. Nick Gorham says it's because the driver and the driver
>managerwait mutually for each other, IIRC. 
 
I have been trying it; I get a segfault (7.1beta4), but haven't yet been
able to determine the cause.  Has anyone got any hints on debugging shared
libraries?

... >In the first case, I can do nothing : I'm reluctant to try to rebuild >the Debian packages from source (I don't
kniowhow to do this from the >sources and Oliver's patches). It follows that I can't do that for the >second either.
 

I make no changes to the ODBC library.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "The LORD is my shepherd; I shall not want. He maketh      me to lie down in
greenpastures: he leadeth me beside     the still waters, he restoreth my soul...Surely     goodness and mercy shall
followme all the days of my     life; and I will dwell in the house of the LORD for     ever."
Psalms23:1,2,6