Re: PLPerl - Undefined symbol "MemoryContextSwitchTo"

From: Doug Sampson <dougs(at)dawnsign(dot)com>
To: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PLPerl - Undefined symbol "MemoryContextSwitchTo"
Date: 2009-11-20 19:31:50
Message-ID: D05FCB8B5D9E904981802903D84EEFEF3D4E@hydra.dawnsign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > Doug Sampson <dougs(at)dawnsign(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-11-20 19:35:27 Re: Books
Previous Message Joshua D. Drake 2009-11-20 18:53:00 Re: Is there a tool used to display statement times from postgres logs