postgresql procedural language

[Fajar Priyanto]

On Thursday 14 July 2005 22:47, Dennis Kaarsemaker wrote:
> On do, 2005-07-14 at 21:59 +0700, Fajar Priyanto wrote:
> > 'postgresql-pl'
>
> pgplsh - PL/sh procedural language for PostgreSQL

Thanks guys,
Seems like the postgresql server looks in another directory for the 
plpgsql.so. It tries to look in /usr/lib/pgsql/plpgsql.so, while in reality, 
the file is located in /usr/lib/postgresql/lib/plpgsql.so

So, after softlinking it:
sudo mkdir /usr/lib/pgsql
sudo ln -s /usr/lib/postgresql/lib/plpgsql.so /usr/lib/pgsql/plpgsql.so

sudo /service/postgresql restart

All is fine now :)
Thanks.
-- 
Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org
Ubuntu Hoary 5.0.4
public key: https://www.arinet.org/fajar-pub.key