Udo Polder <udo.polder@gmail.com> writes:
> I had some error today at a customer and i figured out, the problem is
> triggered by postgres doing an insert on a table with wrong data (not
> even provided), when it should insert the data.
> After some playing around with the query, the error just went away,
> magically ….
Hmmm...
> Postgres is:
> PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu,
> compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
If it's really 14.1, that's quite ancient and full of known bugs.
The first thing you ought to do is update to latest minor release,
14.17. I did not look at the release notes to see if any fixes
overlap this area, but it'd be silly to spend a lot of time
tracking down a problem only to find it's already fixed.
regards, tom lane
