Re: PLPerl not installed correctly? - Mailing list pgsql-novice

From Tim Bunce
Subject Re: PLPerl not installed correctly?
Date
Msg-id 20100423103112.GL78694@timac.local
Whole thread Raw
In response to Re: PLPerl not installed correctly?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Tue, Apr 20, 2010 at 11:21:55AM -0400, Tom Lane wrote:
> "Daniel Hutchison" <Daniel.Hutchison@rokaconsulting.com> writes:
> > I've been experiencing problems getting any plperl function working, and I
> > believe the problem lies in the actual plperl installation not due to my
> > rusty perl memories.  For example, the very simple plperl example in the
> > comprehensive documentation (at
> > http://www.postgresql.org/docs/8.4/interactive/plperl-funcs.html):
> > Returns something odd (at least to me, also with little postgresql
> > experience):
> > prod1=> select perl_max(1,2);
> > ERROR:  invalid input syntax for integer: "CODE(0x1f6d13c)"
>
> I'm going to guess that your perl installation doesn't match the version
> of perl your postgresql installation was built against.

Or perhaps it's picking up the wrong version of the plperl shared lib.

This should work for finding the perl (not plperl) version:
create function perl_ver() RETURNS void AS $$ warn $] $$ language plperl;
select perl_ver();
NOTICE:  5.008008 at line 1.

Tim.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: set default: question
Next
From: Giancarlo Boaron
Date:
Subject: ...