Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSY0x-000I00-15 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Dec 2025 09:58:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vSY0v-00GDkD-2x for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Dec 2025 09:58:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSY0v-00GDk5-0M for pgsql-hackers@lists.postgresql.org; Mon, 08 Dec 2025 09:58:41 +0000 Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSY0s-003pDU-29 for pgsql-hackers@postgresql.org; Mon, 08 Dec 2025 09:58:41 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfhigh.stl.internal (Postfix) with ESMTP id 598F17A0195; Mon, 8 Dec 2025 04:58:35 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Mon, 08 Dec 2025 04:58:35 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm2; t=1765187915; x= 1765274315; bh=ztfDnbOtH73ezQGebBk0OiPG9dIKLfyZs8Q0ta7w7ho=; b=C 7zWnF2yJ1qeTtBPojxBewHPybbF2ZB4FsAPltVCBNvqE66Fi7sHRSgB/kgguiiJs 1a4vYQrP3BjMOtCRYzU7Dd43AFbGirbILJRQAxRpsNuHKjxyYyQltwFFbdgG5ycF EkptN6tYDaGZs80qoEeG5spStRjiLOABtXzevHUfGdjBbxYguen65g26PYaImwtD q/IJ4hsy2AupwqmMPlf13Lq70TD77jnxkFiJaOFyJniohIQMH6aHbbVRSVi/J8ab wRU/tr5BFEGFHsNcClvp5vSw/Xyv4cfMbc64auHgkXCpdKq94QKNH7TXbBVxU5oR PBDYAALyrwj53wNwTJAFw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1765187915; x=1765274315; bh=z tfDnbOtH73ezQGebBk0OiPG9dIKLfyZs8Q0ta7w7ho=; b=acQFoUWp7PON6FsP6 ieMffGBUhFBOG4btv/Zk/6+rWYCGzp1G2VsYT5YQkHNwjvM56iC/Yw19zm8RkVzE Q33wIP2nemcSr3t6nUg6MFlUeE5Ra1LVh6FeaA1cZLAOSpICJyZHm5vRfQGzKdJC USVmXTB/Ql6Kyay5ZmfHk2Wa7UmYaF5FSIfglRj9TrsR6ucNaixbz6iyuOpYwC5Q s2FquoQUOAcLiVeXw6phYyZx3oPrNnKbkEntZNOAodbIhqwZi4fIBVe4L6o2t9cq 140gVTZB88mTUnvTvy+OhFLF9gAWEMK9hO3yCukM22AddU+Km4eSKkaKUbRrQPmn ghgLg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduieefkecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepteeuvdehffekvefgueehveetveekgfegtddtueefueehuddutdfhfeff hfejfeffnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohephedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepvgigtghluhhsihhonhesghhmrghilhdrtghomhdprhgtphhtthho pehmihhhrghilhhnihhkrghlrgihvghusehgmhgrihhlrdgtohhmpdhrtghpthhtohepnh horghhsehlvggruggsohgrthdrtghomhdprhgtphhtthhopehmihgthhgrvghlsehprghq uhhivghrrdighiiipdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtgh hrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 8 Dec 2025 04:58:34 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1765187913; bh=v/Y9bJoDukiwJ9PmSNpuwNIMqBFbnpngUIG1+B8bBt0=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=fEaVFUP0tEnX/7c6+gcVTqacSsF6RR4IREXgJCz50C+2bFZF/zqzUdYMSh0gOAluD cDX3i1fw9PfcdGhCiEp5y04mr6uB3ZAAv/f5MCuDnkcJ7jrT96DTBYFGYDshmjh4GK 0FLeo+gukr+FFYc7r6zHW4F+iNGRm1ffLLEYpyQncFbbrmS1tv+aiesKF/eKbjuPVz feDxvXvYBOHOHpqIgKvJmJyh2Ihg7WLP6qlnQciKvwibdg2ozvePBn4snMVoJJuqxG qCiBNNzAci+tXc2cjVwnKHKHZ4vAJu5hYaa70Y6/dQQ0bKsxuVyDqi2u4z5/mX6bfr hhFsQ5B98cF3w== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 29AA07B; Mon, 08 Dec 2025 10:58:33 +0100 (CET) Date: Mon, 8 Dec 2025 10:58:33 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Mihail Nikalayeu Cc: Alexander Lakhin , Michael Paquier , Noah Misch , PostgreSQL Hackers Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Message-ID: <202512080955.y7zzghv4vag2@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Dec-06, Mihail Nikalayeu wrote: > From my perspective, the correct solution - is to just remove the > error message, because it looks obsolete now. Rereading this -- did you mean to propose that a possible fix was to remove the "invalid arbiter index list" error? I had understood something different. Your idea downthread of changing the way that check works (so that we don't throw an error in this case, but we continue to double-check that the arbiter list is sensible) sounds reasonable to me. Do you want to propose a specific check for it? -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ really, I see PHP as like a strange amalgamation of C, Perl, Shell inflex: you know that "amalgam" means "mixture with mercury", more or less, right? i.e., "deadly poison"