On 06/27/2018 09:55 AM, Moreno Andreo wrote:
Il 22/06/2018 19:56, Adrian Klaver ha scritto:
On 06/22/2018 09:50 AM, Moreno Andreo wrote:
Il 22/06/2018 15:18, Adrian Klaver ha scritto:
I am at a loss now. The only thing I can think of is that data itself
is actually corrupted. Maybe some sort of language encoding/collation
issue. Just not sure how to test that at the moment.
Actually, I tried it in a bunch of other fields with varying data types
and everything went fine.
I don't know if it's as you say and I mismatched keys (and I need
another pair of glasses) or something else. Just hoping (but being
confident) it won't happen again.
You might try emailing the pgcrypto author
https://www.postgresql.org/docs/10/static/pgcrypto.html#id-1.11.7.35.11
In the source code I noticed that there are many:
px_debug('Some text')
that map to:
{PXE_PGP_CORRUPT_DATA, "Wrong key or corrupt data"}.
I tried running with messages set to DEBUG to see if I could get at the
more specific messages. That did not work, so you might ask the author
if there is a way to get at them.
Now trying to speed up a little some queries involving SELECTing among
these encrypted fields, if I'm stuck I'll open a new thread.
Thanks,
Moreno.-
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
