PLPerl - Undefined symbol "MemoryContextSwitchTo"

From: Doug Sampson <dougs(at)dawnsign(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: PLPerl - Undefined symbol "MemoryContextSwitchTo"
Date: 2009-11-20 15:51:58
Message-ID: D05FCB8B5D9E904981802903D84EEFEF3D4B@hydra.dawnsign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Due to database corruption, I had to rebuild a database. Originally we
installed PGSQL 7.4 and over the years bumped it up to 8.0. Now I would like
to use 8.4.

I'm trying to apply the plperl language to a 8.4.0_1 SQL_ASCII database and
I keep getting this error message:

orion-root@/home/postgres: createlang plperl erp
createlang: language installation failed: ERROR: could not load library
"/usr/local/lib/postgresql/plperl.so": dlopen
(/usr/local/lib/postgresql/plperl.so) failed:
/usr/local/lib/postgresql/plperl.so: Undefined symbol
"MemoryContextSwitchTo"

I checked to see if p5-postgresql-plperl was installed and it wasn't.

orion-root@/usr/ports: portversion -v | grep p5-postgresql-plperl
orion-root@/usr/ports:

I noticed this:

orion-root@/usr/ports: make search name=postgresql-plperl
Port: postgresql-plperl-7.4.25_1
Path: /usr/ports/databases/p5-postgresql-plperl
Info: Write SQL functions for PostgreSQL using Perl5
Maint: girgen(at)FreeBSD(dot)org
B-deps: gettext-0.17_1 gmake-3.81_3 libiconv-1.13.1 perl-5.8.9_3
R-deps: gettext-0.17_1 libiconv-1.13.1 perl-5.8.9_3 postgresql-client-7.4.25
postgresql-server-7.4.25
WWW: http://www.postgresql.org/

I find this surprising that the plperl module depends on an older version of
PGSQL! Perl 5.8.9 is also depended on. I'm running Perl 5.10.1.

orion-root@/home/postgres: uname -a
FreeBSD orion.dawnsign.com 7.1-RELEASE-p3 FreeBSD 7.1-RELEASE-p3 #3: Fri Feb
27 14:11:28 PST 2009
root(at)orion(dot)dawnsign(dot)com:/usr/obj/usr/src/sys/ORION-SMP i386

Does this mean I have to revert back to the older version of PGSQL as well
as an older version of Perl in order to install plperl language support?

~Doug

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-20 16:07:27 Re: PLPerl - Undefined symbol "MemoryContextSwitchTo"
Previous Message Matthew Wakeling 2009-11-20 15:08:00 Re: [PERFORM] Strange performance degradation