Re: Building ODBC driver issue - Mailing list pgsql-odbc
From | Hiroshi Saito |
---|---|
Subject | Re: Building ODBC driver issue |
Date | |
Msg-id | 012a01c861be$ecacfea0$0301a8c0@HP22720319231 Whole thread Raw |
In response to | Building ODBC driver issue (Lathrop_Steve@emc.com) |
List | pgsql-odbc |
Hi. Ooop sorry, I forgot the report to you. Fixed this. Subject: [COMMITTERS] psqlodbc - psqlodbc: Fix problem disable of USE_SSL. > Log Message: > ----------- > Fix problem disable of USE_SSL. > Per report Stephen M. Lathrop. > > Modified Files: > -------------- > psqlodbc: > configure.ac (r1.72 -> r1.73) > (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/configure.ac.diff?r1=1.72&r2=1.73) > Thanks! Regards, Hiroshi Saito From: <Lathrop_Steve@emc.com> I don't have openssl installed on my machine, so, I also had to modify socket.c to: #ifdef USE_SSL #include <openssl/ssl.h> #endif -----Original Message----- From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp] Sent: Friday, January 25, 2008 11:16 AM To: Lathrop, Steve; pgsql-odbc@postgresql.org Subject: Re: [ODBC] Building ODBC driver issue Hi. Uga...Surely disable was not effective:-( ....sorry. Although it is ad hoc, please comment out USE_SSL of config.h for yourself. I will improve again. Thanks this report! Regards, Hiroshi Saito ----- Original Message ----- From: <Lathrop_Steve@emc.com> To: <pgsql-odbc@postgresql.org> Sent: Friday, January 25, 2008 11:42 PM Subject: [ODBC] Building ODBC driver issue I am having a problem building the Postgresql ODBC driver without openSSL. The output from the 1 % export PG_CONFIG=/c4_working/postgresql/pgsql/bin/pg_config 2 % export LD_LIBRARY_PATH=/c4_working/postgresql/iODBC/lib 3 % ls /c4_working/postgresql/pgsql/bin/pg_config /c4_working/postgresql/pgsql/bin/pg_config* 4 % ls /c4_working/postgresql/iODBC/lib ./ libiodbcinst.la* libiodbc.la* libodbc.a@ ../ libiodbcinst.so@ libiodbc.so@ libodbc.so@ libiodbc.a libiodbcinst.so.2@ libiodbc.so.2@ pkgconfig/ libiodbcinst.a libiodbcinst.so.2.1.18* libiodbc.so.2.1.18* 5 % ./configure --disable-openssl --with-iodbc=/c4_working/postgresql/iODBC --prefix=/c4_working/postgresql/psqlodbc --exec-prefix=/c4_working/postgresql/psqlodbc --enable-shared checking for a BSD-compatible install... /usr/bin/install -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 configure: using -I/c4_working/postgresql/iODBC/include -L/c4_working/postgresql/iODBC/lib -liodbc -liodbcinst checking for pg_config... /c4_working/postgresql/pgsql/bin/pg_config 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 ISO C89... none needed checking for style of include used by make... GNU checking dependency style of gcc... gcc3 checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking for a sed that does not truncate output... /usr/bin/sed checking for grep that handles long lines and -e... /usr/bin/grep checking for egrep... /usr/bin/grep -E checking for ld used by gcc... /usr/x86_64-suse-linux/bin/ld checking if the linker (/usr/x86_64-suse-linux/bin/ld) is GNU ld... yes checking for /usr/x86_64-suse-linux/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking how to run the C preprocessor... gcc -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... gcc3 checking how to run the C++ preprocessor... g++ -E checking for g77... no checking for f77... no checking for xlf... no checking for frt... no checking for pgf77... no checking for cf77... no checking for fort77... no checking for fl32... no checking for af77... no checking for f90... no checking for xlf90... no checking for pgf90... no checking for pghpf... no checking for epcf90... no checking for gfortran... no checking for g95... no checking for f95... no checking for fort... no checking for xlf95... no checking for ifort... no checking for ifc... no checking for efc... no checking for pgf95... no checking for lf95... no checking for ftn... no checking whether we are using the GNU Fortran 77 compiler... no checking whether accepts -g... no checking the maximum length of command line arguments... 32768 checking command to parse /usr/bin/nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... cat: /etc/ld.so.conf.d/*.conf: No such file or directory GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking for shl_load... no checking for shl_load in -ldld... no checking for dlopen... yes checking whether a program can dlopen itself... yes checking whether a statically linked program can dlopen itself... no checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/x86_64-suse-linux/bin/ld -m elf_x86_64 checking if the linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) is GNU ld... yes checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... yes checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) supports shared libraries... yes checking dynamic linker characteristics... cat: /etc/ld.so.conf.d/*.conf: No such file or directory GNU/Linux ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking for library containing SQLGetPrivateProfileString... none required checking for pthread_create in -lpthreads... no checking for pthread_create in -lpthread... yes checking locale.h usability... yes checking locale.h presence... yes checking for locale.h... yes checking sys/un.h usability... yes checking sys/un.h presence... yes checking for sys/un.h... yes checking sys/time.h usability... yes checking sys/time.h presence... yes checking for sys/time.h... yes checking whether time.h and sys/time.h may both be included... yes checking for long... yes checking size of long... 8 checking for void *... yes checking size of void *... 8 checking for long long... yes checking for ssize_t... yes checking for size_t... yes checking whether struct tm is in sys/time.h or time.h... time.h checking for struct addrinfo... yes checking for an ANSI C-conforming const... yes checking for strerror_r... yes checking for strtoul... yes checking for strtoll... yes checking for iswascii... no checking for localtime_r... yes checking for strtok_r... yes checking for pthread_mutexattr_settype... yes configure: creating ./config.status config.status: creating Makefile config.status: creating config.h config.status: config.h is unchanged config.status: executing depfiles commands 6 % make clean test -z "psqlodbcw.la" || rm -f psqlodbcw.la rm -f "./so_locations" rm -rf .libs _libs rm -f *.o rm -f *.lo 7 % make make all-am make[1]: Entering directory `/c4_working/postgresql/psqlodbc-08.02.0500' if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF ".deps/info.Tpo" -c -o info.lo info.c; \ then mv -f ".deps/info.Tpo" ".deps/info.Plo"; else rm -f ".deps/info.Tpo"; exit 1; fi mkdir .libs gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF .deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF ".deps/bind.Tpo" -c -o bind.lo bind.c; \ then mv -f ".deps/bind.Tpo" ".deps/bind.Plo"; else rm -f ".deps/bind.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF .deps/bind.Tpo -c bind.c -fPIC -DPIC -o .libs/bind.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP -MF ".deps/columninfo.Tpo" -c -o columninfo.lo columninfo.c; \ then mv -f ".deps/columninfo.Tpo" ".deps/columninfo.Plo"; else rm -f ".deps/columninfo.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP -MF .deps/columninfo.Tpo -c columninfo.c -fPIC -DPIC -o .libs/columninfo.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP -MF ".deps/connection.Tpo" -c -o connection.lo connection.c; \ then mv -f ".deps/connection.Tpo" ".deps/connection.Plo"; else rm -f ".deps/connection.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP -MF .deps/connection.Tpo -c connection.c -fPIC -DPIC -o .libs/connection.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF ".deps/convert.Tpo" -c -o convert.lo convert.c; \ then mv -f ".deps/convert.Tpo" ".deps/convert.Plo"; else rm -f ".deps/convert.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF .deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF ".deps/drvconn.Tpo" -c -o drvconn.lo drvconn.c; \ then mv -f ".deps/drvconn.Tpo" ".deps/drvconn.Plo"; else rm -f ".deps/drvconn.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF .deps/drvconn.Tpo -c drvconn.c -fPIC -DPIC -o .libs/drvconn.o drvconn.c: In function 'dconn_get_connect_attributes': drvconn.c:492: warning: passing argument 1 of 'dconn_get_attributes' from incompatible pointer type drvconn.c: In function 'dconn_get_common_attributes': drvconn.c:498: warning: passing argument 1 of 'dconn_get_attributes' from incompatible pointer type if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF ".deps/environ.Tpo" -c -o environ.lo environ.c; \ then mv -f ".deps/environ.Tpo" ".deps/environ.Plo"; else rm -f ".deps/environ.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF .deps/environ.Tpo -c environ.c -fPIC -DPIC -o .libs/environ.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF ".deps/execute.Tpo" -c -o execute.lo execute.c; \ then mv -f ".deps/execute.Tpo" ".deps/execute.Plo"; else rm -f ".deps/execute.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF .deps/execute.Tpo -c execute.c -fPIC -DPIC -o .libs/execute.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF ".deps/lobj.Tpo" -c -o lobj.lo lobj.c; \ then mv -f ".deps/lobj.Tpo" ".deps/lobj.Plo"; else rm -f ".deps/lobj.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF .deps/lobj.Tpo -c lobj.c -fPIC -DPIC -o .libs/lobj.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF ".deps/win_md5.Tpo" -c -o win_md5.lo win_md5.c; \ then mv -f ".deps/win_md5.Tpo" ".deps/win_md5.Plo"; else rm -f ".deps/win_md5.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF .deps/win_md5.Tpo -c win_md5.c -fPIC -DPIC -o .libs/win_md5.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF ".deps/misc.Tpo" -c -o misc.lo misc.c; \ then mv -f ".deps/misc.Tpo" ".deps/misc.Plo"; else rm -f ".deps/misc.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF .deps/misc.Tpo -c misc.c -fPIC -DPIC -o .libs/misc.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF ".deps/options.Tpo" -c -o options.lo options.c; \ then mv -f ".deps/options.Tpo" ".deps/options.Plo"; else rm -f ".deps/options.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF .deps/options.Tpo -c options.c -fPIC -DPIC -o .libs/options.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF ".deps/pgtypes.Tpo" -c -o pgtypes.lo pgtypes.c; \ then mv -f ".deps/pgtypes.Tpo" ".deps/pgtypes.Plo"; else rm -f ".deps/pgtypes.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF .deps/pgtypes.Tpo -c pgtypes.c -fPIC -DPIC -o .libs/pgtypes.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP -MF ".deps/psqlodbc.Tpo" -c -o psqlodbc.lo psqlodbc.c; \ then mv -f ".deps/psqlodbc.Tpo" ".deps/psqlodbc.Plo"; else rm -f ".deps/psqlodbc.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP -MF .deps/psqlodbc.Tpo -c psqlodbc.c -fPIC -DPIC -o .libs/psqlodbc.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF ".deps/qresult.Tpo" -c -o qresult.lo qresult.c; \ then mv -f ".deps/qresult.Tpo" ".deps/qresult.Plo"; else rm -f ".deps/qresult.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF .deps/qresult.Tpo -c qresult.c -fPIC -DPIC -o .libs/qresult.o if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF ".deps/results.Tpo" -c -o results.lo results.c; \ then mv -f ".deps/results.Tpo" ".deps/results.Plo"; else rm -f ".deps/results.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF .deps/results.Tpo -c results.c -fPIC -DPIC -o .libs/results.o results.c: In function 'enlargeUpdated': results.c:2455: warning: assignment from incompatible pointer type if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF ".deps/socket.Tpo" -c -o socket.lo socket.c; \ then mv -f ".deps/socket.Tpo" ".deps/socket.Plo"; else rm -f ".deps/socket.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include -I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF .deps/socket.Tpo -c socket.c -fPIC -DPIC -o .libs/socket.o socket.c:16:25: error: openssl/ssl.h: No such file or directory socket.c:155: warning: initialization from incompatible pointer type socket.c: In function 'format_sockerr': socket.c:175: warning: cast to pointer from integer of different size socket.c: In function 'SOCK_SSL_recv': socket.c:487: error: 'SSL_ERROR_NONE' undeclared (first use in this function) socket.c:487: error: (Each undeclared identifier is reported only once socket.c:487: error: for each function it appears in.) socket.c:489: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this function) socket.c:495: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in this function) socket.c:498: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this function) socket.c:505: error: 'SSL_ERROR_SSL' undeclared (first use in this function) socket.c:506: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in this function) socket.c: In function 'SOCK_SSL_send': socket.c:532: error: 'SSL_ERROR_NONE' undeclared (first use in this function) socket.c:534: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this function) socket.c:535: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in this function) socket.c:541: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this function) socket.c:548: error: 'SSL_ERROR_SSL' undeclared (first use in this function) socket.c:549: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in this function) make[1]: *** [socket.lo] Error 1 make[1]: Leaving directory `/c4_working/postgresql/psqlodbc-08.02.0500' make: *** [all] Error 2 10 % gcc --version gcc (GCC) 4.1.2 20070115 (prerelease) (SUSE Linux) Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 11 % uname -a Linux c4dev-lathrs1 2.6.16.46-0.14-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux __________________ Stephen M. Lathrop mailto:lathrop_steve@emc.com EMC Corporation phone: (508) 305-8596 32 Coslin Drive internal: 824-48596 Southboro, MA 01772 fax: (508) 305-8474 www.emc.com Have-a-heck-of-a-day 4 under 4 apart ---------------------------(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
pgsql-odbc by date: