Re: Pg 9.1.3 pg_crypto question

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(at)bzzagent(dot)com> 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
>