From: Tom Lane <tgl@sss.pgh.pa.us>
To: marco.lebahn@kfw.de
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19335: the function encrypt does not work correct - ERROR:
 encrypt error: Key was too big
In-reply-to: <19335-0ba21e6ccf61a219@postgresql.org>
References: <19335-0ba21e6ccf61a219@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Thu, 27 Nov 2025 08:55:14 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <126275.1764259267.1@sss.pgh.pa.us>
Date: Thu, 27 Nov 2025 11:01:07 -0500
Message-ID: <126276.1764259267@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/126276.1764259267%40sss.pgh.pa.us>
Precedence: bulk

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