From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data |
Date: | 2018-06-21 21:31:16 |
Message-ID: | 94ecaa31-5960-6264-81f9-c8560a3f9fed@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David Pacheco | 2018-06-21 23:22:02 | Re: Can PostgreSQL create new WAL files instead of reusing old ones? |
Previous Message | Tom Lane | 2018-06-21 21:08:07 | Re: SQL Query never ending... |