Обсуждение: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

The following bug has been logged on the website:

Bug reference:      6363
Logged by:          Dean Schulze
Email address:      dean.w.schulze@gmail.com
PostgreSQL version: 9.1.1
Operating system:   Windows 7 Pro 64-bit
Description:=20=20=20=20=20=20=20=20

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
LINE 1: insert into credentials values('demo', pgp_sym_encrypt('pass...
                                               ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.

********** Error **********

ERROR: function pgp_sym_encrypt(unknown, unknown) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need
to add explicit type casts.
Character: 40

Excerpts from dean.w.schulze's message of mi=C3=A9 dic 28 20:21:08 -0300 20=
11:

> The following worked in 8.4, but fails in 9.1.  (pgpcrypto is installed.)
>=20
> In 9.1 it looks like it doesn't recognize strings.
>=20
> insert into credentials values('demo', pgp_sym_encrypt('password',
> 'longpassword'));
>=20
>=20
> 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

--=20
=C3=81lvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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/

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@commandprompt.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