BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1
| От | dean.w.schulze@gmail.com |
|---|---|
| Тема | BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1 |
| Дата | |
| Msg-id | E1Rg2o0-0005Pk-L8@wrigleys.postgresql.org обсуждение |
| Ответы |
Re: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1
|
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: