Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master
Date: 2026-08-31 22:21:48
Message-ID: CADzfLwVpcW36ybdHrxevg_PjFBUUuD13LBhNrXFFKcDnLamLpQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

What I understood - the issue is a little bit wider, it also may
appear on a named constraint - there it is not checked for both
`deferrable` and `nulls not distinct` to be matching original index
itself.

Going to do something with it in near future.

Mikhail.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kiran Kaki 2026-08-31 22:26:10 Re: WAIT FOR NO_THROW option could use some documentation
Previous Message Bharath Rupireddy 2026-08-31 22:10:08 Re: [PATCH] Release replication slot on error in SQL-callable slot functions