Procedural Language module loading on Solaris/GCC

From: Ross Johnson <rpj(at)ise(dot)canberra(dot)edu(dot)au>
To: pgsql-ports(at)hub(dot)org
Subject: Procedural Language module loading on Solaris/GCC
Date: 2000-07-20 05:14:30
Message-ID: 39768AB6.E2B1D453@ise.canberra.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Hi,

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
the examples in chapter 12 of the programmer's reference.

I get identical errors in the output file test.out
when I run "runtest" in postgresql-7.0.2/src/pl/plpgsql/test .

...
insert into Room values ('105', 'Office');
insert into Room values ('106', 'Office');
insert into WSlot values ('WS.001.1a', '001', '', '');
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
insert into WSlot values ('WS.001.1b', '001', '', '');
psql:test.sql:19: 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
...

etc etc

The symbol CurrentMemoryContext is defined in the postmaster backend ok:

> nm postmaster | grep CurrentMemoryContext
[4173] | 2224660| 4|OBJT |GLOB |0 |14
|CurrentMemoryContext

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.

I also tried building with Sun's C compiler but I get alot of errors
and have not succeeded in building the package yet using it.
I'll post something about that as a separate message.

Any ideas?

Thanks
Ross

--
+----------------------+---+
| Ross Johnson | | E-Mail: rpj(at)ise(dot)canberra(dot)edu(dot)au
| Info Sciences and Eng|___|
| University of Canberra | FAX: +61 6 2015227
| PO Box 1 |
| Belconnen ACT 2616 | WWW: http://willow.canberra.edu.au/~rpj/
| AUSTRALIA |
+--------------------------+

Responses

Browse pgsql-ports by date

  From Date Subject
Next Message Urban Widmark 2000-07-20 22:07:21 Re: Procedural Language module loading on Solaris/GCC
Previous Message Peter Eisentraut 2000-07-19 22:46:01 Re: Shared library search paths