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

2011-12-30 Thread Dean Schulze
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 alvhe...@commandprompt.com wrote:

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

2011-12-29 Thread Alvaro Herrera
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'));

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

2011-12-29 Thread Magnus Hagander
On Thu, Dec 29, 2011 at 14:14, Alvaro Herrera alvhe...@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

[BUGS] BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

2011-12-28 Thread dean . w . schulze
The following bug has been logged on the website: Bug reference: 6363 Logged by: Dean Schulze Email address: dean.w.schu...@gmail.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.