Lists: | pgsql-bugs |
---|
From: | dean(dot)w(dot)schulze(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1 |
Date: | 2011-12-28 23:21:08 |
Message-ID: | E1Rg2o0-0005Pk-L8@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6363
Logged by: Dean Schulze
Email address: dean(dot)w(dot)schulze(at)gmail(dot)com
PostgreSQL version: 9.1.1
Operating system: Windows 7 Pro 64-bit
Description:
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
From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | dean(dot)w(dot)schulze <dean(dot)w(dot)schulze(at)gmail(dot)com> |
Cc: | Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1 |
Date: | 2011-12-29 13:14:22 |
Message-ID: | 1325164357-sup-8785@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | "dean(dot)w(dot)schulze" <dean(dot)w(dot)schulze(at)gmail(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1 |
Date: | 2011-12-29 14:00:27 |
Message-ID: | CABUevExGq+s=tf+3Ro+GveSkE7bo7AxZVKzSwirR1PHN+M8K3g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From: | Dean Schulze <dean(dot)w(dot)schulze(at)gmail(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1 |
Date: | 2011-12-31 00:56:49 |
Message-ID: | 4EFE5DD1.2020600@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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