Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-ports by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group