Thread: unixODBC distribution installs newer odbcpsql libs than postgresql?
Hi! If I configure and build postgresql's src/interfaces/odbc for unix ODBC client support, using --with-unixodbc, postgresql installs a version `0' of the library libodbcpsql.so.0. But, the unixODBC distribution already installed a version `1' and `2' of the same lib: $ cd /usr/local/lib $ ls -lF libodbcpsql* -rw-r--r-- 1 root wheel 256918 Feb 5 03:11 libodbcpsql.a lrwxr-xr-x 1 root wheel 16 Feb 5 03:11 libodbcpsql.so@ -> libodbcpsql.so.0 -rwxr-xr-x 1 root wheel 194362 Feb 5 03:11 libodbcpsql.so.0* -rwxr-xr-x 1 root wheel 233771 Feb 5 02:31 libodbcpsql.so.1* -rwxr-xr-x 1 root wheel 244188 Feb 5 02:31 libodbcpsql.so.2* -rw-r--r-- 1 root wheel 4286 Feb 5 02:31 libodbcpsqlS.a lrwxr-xr-x 1 root wheel 17 Feb 5 02:31 libodbcpsqlS.so@ -> libodbcpsqlS.so.1 I installed the unixODBC at 02:31, and postgres odbc at 03:11... (sic...), anyway, unixODBC apparently has support for postgresql built in. Which distribution should I use and recommend? Best regards, Palle Girgensohn
Palle Girgensohn writes: > I installed the unixODBC at 02:31, and postgres odbc at 03:11... (sic...), > anyway, unixODBC apparently has support for postgresql built in. Which > distribution should I use and recommend? The PostgreSQL ODBC driver has seen a lot of work since 7.1. At first glance, it doesn't seem like unixODBC has merged up on those yet. The version number choice is bogus and can be ignored. -- Peter Eisentraut peter_e@gmx.net
--On Monday, February 04, 2002 23:28:16 -0500 Peter Eisentraut <peter_e@gmx.net> wrote: > Palle Girgensohn writes: > >> I installed the unixODBC at 02:31, and postgres odbc at 03:11... >> (sic...), anyway, unixODBC apparently has support for postgresql built >> in. Which distribution should I use and recommend? > > The PostgreSQL ODBC driver has seen a lot of work since 7.1. At first > glance, it doesn't seem like unixODBC has merged up on those yet. The > version number choice is bogus and can be ignored. OK. I'm preparing the ports collection for FreeBSD, so I will have to add a note about this, I guess... This would be very confusing for users. Maybe we could bump the .so version number? Or perhaps, the unixODBC people be pursuaded to merge up? /Palle
Hi again, I see a big problem here, if a sysadm first installs unixODBC, then postgres-odbc, then update unixODBC, the symlink for libodbcpsql.so will point to the latest version, i.e. version `2'. The postgresql has version `0', and version `2' is older and less functional... This is very confusing. Can we do anything about it? :( /Palle --On Tuesday, February 05, 2002 11:52:52 +0100 Palle Girgensohn <girgen@partitur.se> wrote: > --On Monday, February 04, 2002 23:28:16 -0500 Peter Eisentraut > <peter_e@gmx.net> wrote: > >> Palle Girgensohn writes: >> >>> I installed the unixODBC at 02:31, and postgres odbc at 03:11... >>> (sic...), anyway, unixODBC apparently has support for postgresql built >>> in. Which distribution should I use and recommend? >> >> The PostgreSQL ODBC driver has seen a lot of work since 7.1. At first >> glance, it doesn't seem like unixODBC has merged up on those yet. The >> version number choice is bogus and can be ignored. > > OK. I'm preparing the ports collection for FreeBSD, so I will have to add > a note about this, I guess... This would be very confusing for users. > Maybe we could bump the .so version number? Or perhaps, the unixODBC > people be pursuaded to merge up? > > /Palle