postgresql procedural language
Fajar Priyanto
fajarpri at cbn.net.id
Fri Jul 15 07:56:55 UTC 2005
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
More information about the ubuntu-users
mailing list