Re: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

On Thu, Dec 29, 2011 at 14:14, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
>
> Excerpts from dean.w.schulze's message of mi=E9 dic 28 20:21:08 -0300 201=
1:
>
>> The following worked in 8.4, but fails in 9.1. =A0(pgpcrypto is installe=
d.)
>>
>> In 9.1 it looks like it doesn't recognize strings.
>>
>> insert into credentials values('demo', pgp_sym_encrypt('password',
>> 'longpassword'));
>>
>>
>> ERROR: =A0function pgp_sym_encrypt(unknown, unknown) does not exist
>
> It works fine for me here. =A0Is pgp_sym_encrypt listed in this output?
>
> \dx+ pgcrypto

My guess is that the OP has installed the extension in one database
(maybe "postgres") and tries to use it in another. That's a really
easy mistake to make...

--=20
=A0Magnus Hagander
=A0Me: http://www.hagander.net/
=A0Work: http://www.redpill-linpro.com/