Thanks for the heads-up Neil.
I had trouble loading this library. Any suggestions on debuging this?
user@localhost:~/work/pgsql/contrib/pgcrypto$ make installcheck
make -C ../../src/test/regress pg_regress
make[1]: Entering directory `/home/adler/work/pgsql/src/test/regress'
make[1]: `pg_regress' is up to date.
make[1]: Leaving directory `/home/adler/work/pgsql/src/test/regress'
../../src/test/regress/pg_regress init md5 sha1 hmac-md5 hmac-sha1
blowfish rijndael crypt-des crypt-md5 crypt-blowfish crypt-xdes
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== dropping regression test user accounts ==============
ERROR: DROP GROUP: group "regressgroup1" does not exist
============== installing PL/pgSQL ==============
============== running regression test queries ==============
test init ... ERROR: Load of file
/usr/local/pgsql/lib/pgcrypto.so failed: /usr/local/pgsql/lib/pgcrypto.so:
undefined symbol: px_find_dige
st
ERROR: Load of file /usr/local/pgsql/lib/pgcrypto.so failed:
/usr/local/pgsql/lib/pgcrypto.so: undefined symbol: px_find_digest
On Wed, 10 Jul 2002, Neil Conway wrote:
> Date: Wed, 10 Jul 2002 15:46:31 -0400
> From: Neil Conway <nconway@klamath.dyndns.org>
> To: Michael Adler <adler@glimpser.org>
> Cc: postgres list <pgsql-general@postgresql.org>
> Subject: Re: [GENERAL] hash(text) function inside db?
>
> On Wed, Jul 10, 2002 at 03:38:49PM -0400, Michael Adler wrote:
> > I'd like to be able to get a hash (e.g. md5) of a text datatype inside the
> > database. It looks like this is not included in the default installation.
>
> Try contrib/pgcrypto
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilconway@rogers.com>
> PGP Key ID: DB3C29FC
>
Mike