Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marco(dot)lebahn(at)kfw(dot)de
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big
Date: 2025-11-27 16:01:07
Message-ID: 126276.1764259267@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> we patched our Systems from 16.10 and 14.19 to the new minor-level 16.11 and
> 14.20.
> No problems with 16.10 and 14.19 while we using the function encrypt and
> decrypt
> After patching the function throws errors

These examples work fine for me in 16.11, and nothing in the
contrib/pgcrypto source code changed between 16.10 and 16.11.

Since pgcrypto depends on OpenSSL, one possible theory is that
your new pgcrypto.so was built against a different version of
OpenSSL than what is installed on your machine. But with no
info about how you did the update, that's only wild speculation.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2025-11-27 17:51:43 Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big
Previous Message Álvaro Herrera 2025-11-27 15:55:25 Re: BUG #19336: TRAP: failed Assert("!IsTransactionOrTransactionBlock()")