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]