Package: postgresql-8.1-plr
Severity: normal
Hi,
I followed the installation instructions for postgresql-8.1-plr, to no
avail. My first attempt to load plr.sql yielded:
% psql mydb < /usr/share/postgresql/8.1/plr.sql
SET
ERROR: permission denied for language c
ERROR: must be superuser to create procedural language
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
CREATE TYPE
ERROR: permission denied for language c
ERROR: function plr_environ() does not exist
CREATE TYPE
ERROR: language "plr" does not exist
ERROR: language "plr" does not exist
Fair enough. So I need to be a superuser. But that doesn't seem to work
either:
% sudo -u postgres psql mydb < /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
I assume this might be a dependency problem, but it is not immediately
obvious to me what it is.
Charles
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (800, 'testing'), (70, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16-2-686
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
