To add a language we need to use the following query
create language plpythonu
When I run this query, I was struck up in the following error
"ERROR: could not access file "$libdir/plpython": No such file or directory"
So I google a lot and atlast found the solution .
The problem was plpython package was not installed.
To run plpython routines and procedures,we need the following packages.
postgresql-8.3 (By default postgres-8.3 will be installed)
postgresql-contrib-8.3
postgresql-plpython-8.3
I was using BOSS, a debian derived linux.
I installed the packages with the command
apt-get install postgresql-contrib-8.3
apt-get install postgresql-plpython-8.3
Then I run the same query,
create language plpythonu
Success, that problem was resolved !!!!!
No comments:
Post a Comment