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@bzzagent.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
>