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