Package: postgresql-contrib-9.0
Version: 9.0.4-1~bpo60+1
Hi,
I needed to get SHA-1 support in PostgreSQL. Googling says pgcrypto is the
contrib module to use. So I installed this package, reloaded the server,
digest() wasn't available, restarted it, ditto. More googling then told me
there's /usr/share/postgresql/9.0/contrib/pgcrypto.sql that I need to apply
first. Why couldn't the package or at least mention that?
Only /usr/share/doc/postgresql-contrib-9.0/README is shipped, and it's
apparently completely generic and useless.
So, anyway, I tried applying that file,
% sudo -H -u postgres psql test-sha <
/usr/share/postgresql/9.0/contrib/pgcrypto.sql
SET
ERROR: nemoguć pristup datoteci "$libdir/pgcrypto": No such file or directory
ERROR: nemoguć pristup datoteci "$libdir/pgcrypto": No such file or directory
[...]
(the foreign string is translated "can't access file" or similar)
After some more googling, I find:
test-sha=# show dynamic_library_path;
dynamic_library_path
----------------------
$libdir
(1 row)
So it's usable like that inside special variables, but not from SQL. Argh.
Anyway, from shell, `pg_config --pkglibdir` tells me it's at
/usr/lib/postgresql/9.0/lib
So I hardcode that and try:
CREATE OR REPLACE FUNCTION digest(text, text)
RETURNS bytea
AS '/usr/lib/postgresql/9.0/lib/pgcrypto.so', 'pg_digest'
LANGUAGE C IMMUTABLE STRICT;
But the new output is:
ERROR: neuspjelo čitanje biblioteke "/usr/lib/postgresql/9.0/lib/pgcrypto.so":
/usr/lib/postgresql/9.0/lib/pgcrypto.so: undefined symbol:
cstring_to_text_with_len
(the foreign string is "failed to read library" or similar)
Surely this library isn't supposed to be this hard/impossible to use :)
Please fix this. TIA.
--
2. That which causes joy or happiness.
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
