when testing the ipv6 patch for the most recent version of the odbc
driver I came across a problem with the configure script on Solaris 9:

[postgres@unknown psqlodbc-08.00.0102_64]$
CFLAGS='-I/platdb/odbc64/include/' LDFLAGS='-L/platdb/odbc64/lib'
../configure --prefix=/tmp
checking for a BSD-compatible install... /opt/sfw/bin//ginstall -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking dependency style of gcc... gcc
checking for SQLGetPrivateProfileString in -lodbcinst... no
checking for SQLGetPrivateProfileString in -liodbcinst... no
configure: error: no suitable ODBC driver manager found

i am trying to compile the code with the command line shown above.
however, the unix odbc driver manager is not found although it has been
installed properly:

[postgres@unknown psqlodbc-08.00.0102_64]$ ls -l /platdb/
..profile .tstfile odbc32 odbc64
[postgres@unknown psqlodbc-08.00.0102_64]$ ls -l /platdb/odbc64/lib/libodbc
libodbc.la libodbcdrvcfg1S.so.1.0.0 libodbcinst.so.1
libodbcnnS.so libodbcpsqlS.so.1
libodbc.so libodbcdrvcfg2S.la libodbcinst.so.1.0.0
libodbcnnS.so.1 libodbcpsqlS.so.1.0.0
libodbc.so.1 libodbcdrvcfg2S.so libodbcminiS.la
libodbcnnS.so.1.0.0 libodbctxt.la
libodbc.so.1.0.0 libodbcdrvcfg2S.so.1 libodbcminiS.so
libodbcpsql.la libodbctxt.so
libodbccr.la libodbcdrvcfg2S.so.1.0.0 libodbcminiS.so.1
libodbcpsql.so libodbctxt.so.1
libodbccr.so libodbcextras.la
libodbcminiS.so.1.0.0 libodbcpsql.so.1 libodbctxt.so.1.0.0
libodbccr.so.1 libodbcextras.so libodbcmyS.la
libodbcpsql.so.1.0.0 libodbctxtS.la
libodbccr.so.1.0.0 libodbcextras.so.1 libodbcmyS.so
libodbcpsql.so.2 libodbctxtS.so
libodbcdrvcfg1S.la libodbcextras.so.1.0.0 libodbcmyS.so.1
libodbcpsql.so.2.0.0 libodbctxtS.so.1
libodbcdrvcfg1S.so libodbcinst.la libodbcmyS.so.1.0.0
libodbcpsqlS.la libodbctxtS.so.1.0.0
libodbcdrvcfg1S.so.1 libodbcinst.so libodbcnnS.la
libodbcpsqlS.so
[postgres@unknown psqlodbc-08.00.0102_64]$ ls -l
/platdb/odbc64/lib/libodbcinst.so
lrwxrwxrwx 1 postgres postgres 20 Aug 11 15:17
/platdb/odbc64/lib/libodbcinst.so -> libodbcinst.so.1.0.0


my compile script works perfectly well with the older odbc driver (7). i
have seen that some code has been changed inside the build script. maybe
somebody can point me to a fix.

best regards,

hans



--
Cybertec Geschwinde & Schönig GmbH
Schöngrabern 134; A-2020 Hollabrunn
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match