Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: marco.lebahn@kfw.de
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-11-27T16:01:07Z
Lists: pgsql-bugs
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