Re: PLPerl - Undefined symbol "MemoryContextSwitchTo" - Mailing list pgsql-general

From Doug Sampson
Subject Re: PLPerl - Undefined symbol "MemoryContextSwitchTo"
Date
Msg-id D05FCB8B5D9E904981802903D84EEFEF3D4E@hydra.dawnsign.com
Whole thread Raw
In response to PLPerl - Undefined symbol "MemoryContextSwitchTo"  (Doug Sampson <dougs@dawnsign.com>)
List pgsql-general
> > Doug Sampson <dougs@dawnsign.com> writes:
> > > orion-root@/usr/ports: make search name=postgresql-plperl
> > > Port:   postgresql-plperl-7.4.25_1
> >
> > It would appear that you forgot to update plperl to 8.4 along with
> > the core postgres package ... the error message is not tremendously
> > informative but it seems consistent with the idea of trying to load
> > a 7.4-vintage plperl.so into a modern backend.
> >
>
> I'm no PGSQL expert. Neither am I a FreeBSD expert.
>
> How does one build plperl support into a FreeBSD port of
> postgresql-server

 [...]

>
> Or am I going about this the wrong way? Should I install the
> p5-postgresql-plperl port even though it states that this
> ports depends on
> or are depended by postgresql 7.4 server/client and perl
> 5.8.9? Will the
> p5-postgresql-plperl work with version 8.4.0_1 of PGSQL and
> Perl 5.10.1?
>
> ~Doug
>

I went ahead and installed the p5-postgresql-plperl port and it installed
cleanly. The 'createlang plperl erp' command went through fine. The
installation recognized correctly the current versions of both PGSQL and
Perl and used them.

I am puzzled though as to why it wasn't installed previously for the older
version of PGSQL which apparently had PLPerl support!

Thanks for the assistance!

~Doug

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Easier to use warm standby in 8.4?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Books