Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

[Adrian Klaver]

On 06/21/2018 08:36 AM, Moreno Andreo wrote:

Hi,

    while playing with pgcrypto I ran into a strange issue (postgresql 9.5.3 x86 on Windows 7)

Having a table with a field
dateofbirth text

I made the following sequence of SQL commands

update tbl_p set dateofbirth = pgp_sym_encrypt('2018-06-21', 'AES_KEY') where codguid = '00000001-0001-0001-0001-000000000001';

OK

select pgp_sym_decrypt(dateofbirth::bytea, 'AES_KEY') as datanasc from tbl_p where codguid = '00000001-0001-0001-0001-000000000001'

'2018-06-21'

select * from tab_paz where pgp_sym_decrypt(natoil::bytea, 'AES_KEY') = '2018-06-21'

You switched gears above.

What is the data type of the natoil field in table tab_paz?

Was the data encrypted in it using the 'AES_KEY'?

I can replicate the below by doing:

select pgp_sym_decrypt(pgp_sym_encrypt('2018-06-21', 'AES_KEY'), 'AES');
ERROR:  Wrong key or corrupt data

ERROR:  Wrong key or corrupt data
********** Error **********

ERROR: Wrong key or corrupt data
SQL state: 39000

Can't find reference anywhere...
Any help would be appreciated.
Thanks,
Moreno.-

--
Adrian Klaver
adrian.kla...@aklaver.com