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 wrote: Excerpts from dean.w.schu

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 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 v

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'));

[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. (pgpcryp