Re: Problem with "on conflict"

Udo Polder <udo(dot)polder(at)gmail(dot)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