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

I've requested that this bug be closed. What was happening was that I
was adding pgcrypto to my database, but then deleting and adding the
database. Duh. My bad.

On 12/29/2011 7:00 AM, Magnus Hagander wrote:
> On Thu, Dec 29, 2011 at 14:14, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:
>> 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
> 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...
>

--
Dean
303.909.3245 cell