Dapper version requires additional love:
root@gandalf:/# sudo -u postgres psql plr_test < /usr/share/postgresql/8.1/plr.sql
SET
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: function plr_call_handler() does not exist
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: relation "plr_environ_type" already exists
ERROR: could not load library "/usr/lib/postgresql/8.1/lib/plr.so": libR.so: cannot open shared object file: No such file or directory
ERROR: function plr_environ() does not exist
ERROR: relation "r_typename" already exists
ERROR: language "plr" does not exist
ERROR: language "plr" does not exist
We need to use fix from http://bugs.debian.org/360796.
Confirmed in Gutsy, Feisty, Edgy, and Dapper.
Dapper version requires additional love: postgresql/ 8.1/plr. sql postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory postgresql/ 8.1/lib/ plr.so" : libR.so: cannot open shared object file: No such file or directory bugs.debian. org/360796.
root@gandalf:/# sudo -u postgres psql plr_test < /usr/share/
SET
ERROR: could not load library "/usr/lib/
ERROR: function plr_call_handler() does not exist
ERROR: could not load library "/usr/lib/
ERROR: could not load library "/usr/lib/
ERROR: could not load library "/usr/lib/
ERROR: could not load library "/usr/lib/
ERROR: could not load library "/usr/lib/
ERROR: relation "plr_environ_type" already exists
ERROR: could not load library "/usr/lib/
ERROR: function plr_environ() does not exist
ERROR: relation "r_typename" already exists
ERROR: language "plr" does not exist
ERROR: language "plr" does not exist
We need to use fix from http://