Thread: RE: [INTERFACES] Three posts and no response 8--(

RE: [INTERFACES] Three posts and no response 8--(

From
Daren Sefcik
Date:

On Tuesday, July 13, 1999 6:57 AM, Tom Lane [SMTP:tgl@sss.pgh.pa.us]
wrote:
> Daren Sefcik <daren@partnersdata.com> writes:
> > I know there must be somebody out there who can help me this,I need
help
> > with getting psqlodbc working on Solaris 2.6..when I try to run the
.so
> > file I get the following error:
> 
> > /opt/ISLIodbc/2.11/bin/qetestlib: fatal: relocation error: file
> > /usr/local/pgsql/lib/libpsqlodbc.so: symbol shutdown: referenced
symbol
> > not found 
> 
> This looks like libpsqlodbc.so hasn't been linked to libc.so properly.
> 
> Unfortunately, every flavor of Unix seems to have different ideas
about
> how shared libs should be built :-(, and I have no idea what the magic
> incantation may be on Solaris.  A lot of Unixes require "-lc" to be
> mentioned when linking a shlib that makes use of libc.  You might
> check whether that's happening when libpsqlodbc is built.

How would I go about this..??
I am basically just untarring the archive, doing a configure --with-odbc
and then make, make install.
I do not get any fatal errors, everything completes and installs fine
and postgresql works fine as well.
Should I be doing it different???
I get the feeling I need to add a switch to a makefile or edit my
environment path or something but am
not sure what.


> 
> Which version of Postgres are you using, anyway, and which port
> (solaris_i386 or solaris_sparc)?


Sparc Solaris.

Thanks...
Daren


Re: [INTERFACES] Three posts and no response 8--(

From
Tom Lane
Date:
Daren Sefcik <daren@partnersdata.com> writes:
> I am basically just untarring the archive, doing a configure --with-odbc
> and then make, make install.
> I do not get any fatal errors, everything completes and installs fine
> and postgresql works fine as well.

Do the regression tests pass?

> Should I be doing it different???
> I get the feeling I need to add a switch to a makefile or edit my
> environment path or something but am
> not sure what.

The eventual patch will be a change/addition in src/Makefile.shlib,
in the section for your platform (solaris_sparc).  I am guessing that
we might need to add a line like SHLIB_LINK        += -lc
but at this stage that's no more than a guess.  If that doesn't help,
you could look at the sections for the other platforms and see if you
see any switches that are mentioned in your system's documentation about
shared libs (try "man ld" if you have no other idea where to find it).

After editing Makefile.shlib, you can just go into src/interfaces/odbc
and do "make clean", "make", "make install" --- it shouldn't be
necessary to rebuild all of Postgres.
        regards, tom lane