Re: Pg 9.1.3 pg_crypto question

[Dick Wieland <dick.wieland@xxxxxxxxxx>]

I had the same problem. I can confirm that changing to

bytea_output = 'escape'


restores the previous behavior.



Regards,
Dick Wieland

On 04/10/2012 01:50 PM, Tom Lane wrote:
> Aaron Burnett<aburnett@xxxxxxxxxxxx>  writes:
> > 9.1.3 is just not decrypting nor throwing errors.
> > 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
> > decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
> > 'aes-cbc');
> >          decrypt_iv
> > --------------------------
> > \x48656c6c6f205468657265
> > (1 row)
> I think this is the same result, it's just being shown in hex.
> See the bytea_output configuration parameter.
>
> 			regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general