Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 5B28D9FA4D1;
	Sun, 25 Mar 2007 23:45:50 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 92483-02; Sun, 25 Mar 2007 23:45:29 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id EE3899FA4E5;
	Sun, 25 Mar 2007 23:45:34 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l2Q2jVZA002382;
	Sun, 25 Mar 2007 22:45:31 -0400 (EDT)
To: Sean Davis <sdavis2@mail.nih.gov>
cc: pgsql-interfaces@postgresql.org, pgsql-odbc@postgresql.org
Subject: Re: ODBC for Mac OS 
In-reply-to: <4606AC15.90406@mail.nih.gov> 
References: <4606AC15.90406@mail.nih.gov>
Comments: In-reply-to Sean Davis <sdavis2@mail.nih.gov>
	message dated "Sun, 25 Mar 2007 13:06:29 -0400"
Date: Sun, 25 Mar 2007 22:45:31 -0400
Message-ID: <2381.1174877131@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/34
X-Sequence-Number: 6475

Sean Davis <sdavis2@mail.nih.gov> writes:
> I'm trying to compile psqlodbc-08.02.0200 for Mac OS.  I'm getting the 
> following when I try to do that:

> gcc  -o .libs/psqlodbcw.so -bundle  .libs/info.o .libs/bind.o 
> .libs/columninfo.o .libs/connection.o .libs/convert.o .libs/drvconn.o 
> .libs/environ.o .libs/execute.o .libs/lobj.o .libs/win_md5.o 
> .libs/misc.o .libs/options.o .libs/pgtypes.o .libs/psqlodbc.o 
> .libs/qresult.o .libs/results.o .libs/socket.o .libs/parse.o 
> .libs/statement.o .libs/tuple.o .libs/dlg_specific.o .libs/loadlib.o 
> .libs/multibyte.o .libs/odbcapi.o .libs/descriptor.o .libs/odbcapi30.o 
> .libs/pgapi30.o .libs/info30.o .libs/mylog.o .libs/odbcapi30w.o 
> .libs/odbcapiw.o .libs/win_unicode.o  -L/Users/sdavis/local/pgsql/lib 
> -lpgport -lz -lreadline -lresolv -ldl -lm -lpq
> /usr/bin/ld: Undefined symbols:
> _CONNLOCK_ACQUIRE
> _CONNLOCK_RELEASE
> _INIT_CONNLOCK
> _SSL_get_error
> _SSL_read
> _SSL_write
> _SQLGetPrivateProfileString
> _SQLWritePrivateProfileString
> collect2: ld returned 1 exit status
> make[1]: *** [psqlodbcw.la] Error 1

Darwin is pickier than most other OSes about requiring that all symbols
referenced by a shared library be defined in one or another of the
shared libraries listed when it's linked.  In this case the link command
is clearly missing a -l switch for OpenSSL, and probably a couple other
things.  ODBC guys, can you fix this?

			regards, tom lane