From: Álvaro Herrera <alvherre@kurilemu.de>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master
Date: Fri, 18 Sep 2026 16:46:54 +0200
Message-ID: <aq1On2pG5-NHvF4e@alvherre.pgsql> (raw)
In-Reply-To: <aq1I1vFS-QZWLOMA@ddolgov-thinkpadt14sgen1.rmtde.csb>
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"
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-hackers@postgresql.org
Cc: alvherre@kurilemu.de, 9erthalion6@gmail.com, mihailnikalayeu@gmail.com, michael@paquier.xyz, 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
In-Reply-To: <aq1On2pG5-NHvF4e@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox