Re: [GENERAL] Create language PLPERL error

2009-09-07 Thread Alvaro Herrera
Shakil Shaikh wrote: > -- > From: "Alvaro Herrera" > > >Shakil Shaikh wrote: > > > >> > >>ERROR: could not access file "$libdir/plperl": No such file or directory > >> > >>Apparently this means that the version of Postgresql I have wasn't > >>compi

Re: [GENERAL] Create language PLPERL error

2009-09-05 Thread Shakil Shaikh
-- From: "Alvaro Herrera" Shakil Shaikh wrote: ERROR: could not access file "$libdir/plperl": No such file or directory Apparently this means that the version of Postgresql I have wasn't compiled with support for plperl. How would I find this

Re: [GENERAL] Create language PLPERL error

2009-09-04 Thread Alvaro Herrera
Shakil Shaikh wrote: > I tried installing this but am now getting the following error when > trying to install plperl: > > ERROR: could not access file "$libdir/plperl": No such file or directory > > Apparently this means that the version of Postgresql I have wasn't > compiled with support for

Re: [GENERAL] Create language PLPERL error

2009-09-04 Thread Shakil Shaikh
From: "Alvaro Herrera" Remove that, and install them from Martin Pitt's repository: https://launchpad.net/~pitti/+archive/postgresql The one-click installer does not integrate well with the platform. Avoid using them. Hi, thanks for the tip. I tried installing this but am now getting the fo

Re: [GENERAL] Create language PLPERL error

2009-09-03 Thread Alvaro Herrera
Shakil Shaikh wrote: > Hi all, > > Running Postgres 8.4 on Ubuntu 9.04, installed via the clickonce > installer. Remove that, and install them from Martin Pitt's repository: https://launchpad.net/~pitti/+archive/postgresql The one-click installer does not integrate well with the platform. Avoid

Re: [GENERAL] Create language PLPERL error

2009-09-03 Thread Shakil Shaikh
From: "Tom Lane" You've apparently got a version of libperl.so that is not compatible with the one that your Postgres was built against. There are lots of compile-time options for Perl that affect this, so it's not exactly a surprising situation. The easiest fix is to be sure you get your pos

Re: [GENERAL] Create language PLPERL error

2009-09-03 Thread Tom Lane
"Shakil Shaikh" writes: > Running Postgres 8.4 on Ubuntu 9.04, installed via the clickonce installer. > I'm getting a curious error when trying to create/add support for plperl to > any database: > ERROR: could not load library > "/opt/PostgreSQL/8.4/lib/postgresql/plperl.so": > /opt/Postgre

[GENERAL] Create language PLPERL error

2009-09-03 Thread Shakil Shaikh
Hi all, Running Postgres 8.4 on Ubuntu 9.04, installed via the clickonce installer. I'm getting a curious error when trying to create/add support for plperl to any database: ERROR: could not load library "/opt/PostgreSQL/8.4/lib/postgresql/plperl.so": /opt/PostgreSQL/8.4/lib/postgresql/plp