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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
Cc: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master
Date: 2026-09-18 14:46:54
Message-ID: aq1On2pG5-NHvF4e@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Sep-18, Dmitry Dolgov wrote:

> Yes, I get that. But the way how comment is written seems to emphasize
> interchangeability of indexes in general, mentioning REINDEX
> CONCURRENTLY as one use case, but not necessarily the only one -- or at
> least it's my reading of it. Maybe a better commentary can solve it, but
> since it's already pushed, consider it to be an optional nit pick.

I'll gladly take your nit pick.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
<inflex> really, I see PHP as like a strange amalgamation of C, Perl, Shell
<crab> inflex: you know that "amalgam" means "mixture with mercury",
more or less, right?
<crab> i.e., "deadly poison"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tristan Partin 2026-09-18 14:52:42 Re: Add ASCII fast path to Unicode normalization functions
Previous Message Nathan Bossart 2026-09-18 14:41:04 Re: [PATCH] Reject nonpositive Bloom filter element estimates