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 <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support