Feedback-ID: ie3de48e3:Fastmail
Date: Fri, 18 Sep 2026 16:46:54 +0200
From: =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.de>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Mihail Nikalayeu <mihailnikalayeu@gmail.com>,
	Michael Paquier <michael@paquier.xyz>,
 Zsolt Parragi <zsolt.parragi@percona.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: Routed ON CONFLICT inserts broken by partition-local deferrable
 unique constraints in 19 and master
Message-ID: <aq1On2pG5-NHvF4e@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <aq1I1vFS-QZWLOMA@ddolgov-thinkpadt14sgen1.rmtde.csb>
Archived-At: 
 <https://www.postgresql.org/message-id/aq1On2pG5-NHvF4e%40alvherre.pgsql>
Precedence: bulk

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"