Обсуждение: 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