Thread

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

Tom Lane <tgl@sss.pgh.pa.us> — 2025-11-27T16:01:07Z

PG Bug reporting form <noreply@postgresql.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