agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Udo Polder <udo.polder@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Problem with "on conflict"
Date: Wed, 26 Mar 2025 12:32:53 -0400
Message-ID: <1627987.1743006773@sss.pgh.pa.us> (raw)
In-Reply-To: <939e57d2-9294-4557-b436-eb5e9b268f6f@gmail.com>
References: <939e57d2-9294-4557-b436-eb5e9b268f6f@gmail.com>

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

view thread (3+ messages)

Message-ID: <1627987.1743006773@sss.pgh.pa.us>
Permalink:  ../1627987.1743006773@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1627987.1743006773@sss.pgh.pa.us

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, udo.polder@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Problem with "on conflict"
  In-Reply-To: <1627987.1743006773@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox