Re: [GENERAL] Create language PLPERL error

2009-09-07 Thread Alvaro Herrera
Shakil Shaikh wrote: -- From: Alvaro Herrera alvhe...@commandprompt.com 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

Re: [GENERAL] Create language PLPERL error

2009-09-05 Thread Shakil Shaikh
-- From: Alvaro Herrera alvhe...@commandprompt.com 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

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 plperl.

Re: [GENERAL] Create language PLPERL error

2009-09-04 Thread Shakil Shaikh
From: Alvaro Herrera alvhe...@commandprompt.com 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

[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:

Re: [GENERAL] Create language PLPERL error

2009-09-03 Thread Tom Lane
Shakil Shaikh ssha...@hotmail.com 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:

Re: [GENERAL] Create language PLPERL error

2009-09-03 Thread Shakil Shaikh
From: Tom Lane t...@sss.pgh.pa.us 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

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