Excerpts from dean.w.schulze's message of mié dic 28 20:21:08 -0300 2011:

> The following worked in 8.4, but fails in 9.1.  (pgpcrypto is installed.)
> 
> In 9.1 it looks like it doesn't recognize strings.
> 
> insert into credentials values('demo', pgp_sym_encrypt('password',
> 'longpassword'));
> 
> 
> ERROR:  function pgp_sym_encrypt(unknown, unknown) does not exist

It works fine for me here.  Is pgp_sym_encrypt listed in this output?

\dx+ pgcrypto

-- 
Álvaro Herrera <alvhe...@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to