Re: Procedural Language module loading on Solaris/GCC

On Thu, 20 Jul 2000, Ross Johnson wrote:

> I've built 7.0.2 on Solaris 7 using GCC 2.95.2. All seems to be ok
> except the procedural language module isn't loading. I've tried
[snip]
> psql:test.sql:18: ERROR: Load of file
> /usr/local/postgresql/lib/plpgsql.so failed: ld.so.1:
> /usr/local/postgresql/bin/postmaster: fatal: relocation error: file
> /usr/local/postgresql/lib/plpgsql.so: symbol CurrentMemoryContext:
> referenced symbol not found

Welcome to the club ... :)

> The only other clue I have on this is that the gcc install readme
> suggests using the Sun ld because the GNU ld has some obscure problem
> on Solaris. The build used Sun's ld.

ld from GNU binutils will most likely not make you happier.

You could try the patch below from Carlos Villegas and see if that helps.
It didn't for me (Solaris 2.5.1) so I'm very interested to hear if it
works for you.

/Urban

diff -c -r postgresql-7.0.2/src/backend/port/dynloader/solaris_sparc.h
postgresql-7.0.2-sol26/src/backend/port/dynloader/solaris_sparc.h
*** postgresql-7.0.2/src/backend/port/dynloader/solaris_sparc.h Wed Jan 26 14:56:44 2000
--- postgresql-7.0.2-sol26/src/backend/port/dynloader/solaris_sparc.h Wed Jul 19 00:01:39 2000
***************
*** 31,37 ****
* library as the file to be dynamically loaded.
*
*/
! #define pg_dlopen(f) dlopen(f,1)
#define pg_dlsym dlsym
#define pg_dlclose dlclose
#define pg_dlerror dlerror
--- 31,37 ----
* library as the file to be dynamically loaded.
*
*/
! #define pg_dlopen(f) dlopen(f,1|RTLD_PARENT)
#define pg_dlsym dlsym
#define pg_dlclose dlclose
#define pg_dlerror dlerror