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 1woJ9n-000xtK-2y for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Jul 2026 11:06:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1woJ9m-00CbVN-2i for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Jul 2026 11:06:02 +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 1woJ9l-00CbVF-3B for pgsql-bugs@lists.postgresql.org; Mon, 27 Jul 2026 11:06:02 +0000 Received: from fhigh-b7-smtp.messagingengine.com ([202.12.124.158]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1woJ9i-00000000XSX-3ypF for pgsql-bugs@lists.postgresql.org; Mon, 27 Jul 2026 11:06:01 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfhigh.stl.internal (Postfix) with ESMTP id 148E27A04BB; Mon, 27 Jul 2026 07:05:56 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Mon, 27 Jul 2026 07:05:56 -0400 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=fm1; t=1785150355; x= 1785236755; bh=47xqjOn5VSTsW0ueqV6CadzX8+vYS3mpUEc7RVCOKtw=; b=Q JJvcWuQ5Bme4YuFKlXpuQ1riP1tffkh39ja+EbcoBJjQxL8d5+6adkOMrZSQHh9I nbUVQ/kBaZ1waba+oDzeEkXVMZpIaLlVZDYt6jPyk0p6zRRI+LUnt9bDb4qihwwr q4hN025boj5vTc2n119iislDWc2Sq8yxxVCUqs1tKxxdi0WL3JnXpRIBYNBdTKdG /Z5lvlZwfjZ0JdqENbddzL2HDeZoaGpOqRTQRqTmRS8A+N62i/u0HdbnHNJbmDxA /wvTDnqIfNTkA3e9K+KV2ELR1IAs4hbgenjwZ5hRCeERiZOcqL/vcA3busbeCCsW iouVTzwRpCD+udFMviYWg== 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=fm2; t=1785150355; x=1785236755; bh=4 7xqjOn5VSTsW0ueqV6CadzX8+vYS3mpUEc7RVCOKtw=; b=p6OANXGY4J67BuMJC LQtgGUrHXNPZKpW/+O0Z+j6mVEKoJNDwsMRaUZekNYCJmvSwzbQ/h1NSCCdqWOFF ZL5v0fPPHd2q2Zn9SYwOxvmXjKqoTeHqRJyqrtFmgp4r0kEDoFvNi73h2JnX9g7Y 0+yW4s4YNeVay4QQ4nQQJHv9ogYI1YJMkODt1R+bua8Xe1+9BW/HMK8Bx301oj4d WVXnAvVvX2eGuIeGOEejYpMp0VM429EzYYfVa13ma3IcXr3aWTdmvs/G8mm9TFx7 BY0mSXua1IH6LxRHNHead2HnB4nQtb1lIxdQogJplJJgkBexAXFRkMGpCdV4yeRJ z7e+g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEHMjv+kn8HRgZG73UFRustDglveua05nx/nWWHYvr/d0IeRI0IzpNvv9poYfKgm0 +xR9jvUKGlQmCgEF+I86AFGsYpazfcZefPmUa9CGT/KoC2Xc+21c20q0iuAube1RBOVBUs djZ1ncTxdAaJNAAEUPVujBRT4kq4rDvg5/XdnNRLu9Hx1LMrCfkAkwH0zNjfN+LzHm3rrx 3+IA8AfMN+kieWP1vGl2+lyT/86irkLjQAp/HIi/oMbco4p1Xy7SopITZdXSde/MTZlnlL ZLHtzQG0HtVvmdJ0O/R7trcIUxDcPGP/0nAxry+71xxrvVIT2KKvUmcXdKUS0wlRM8TBMv Xx/Pcs5fG6R+HsJdrv6xRaW2P7IhuBPOxxCVGhBU+GMU3OUaDmAy9exdFDoC045eeSVCcQ 6VVSdOLGhsSkPvYq6JJp3bWLw9z7yCuFqrTRDquvT8kBhSi/sBwDwt+M2UlN3+k6WsUDnq cE9pmmtH8IZVtnKfBgPNu1ZBK6VUAIReUg6ZwiFpIoQNabzfHYTPaZ1SUFEF4bCEplwlEc yvF9Jw9HJw+rD3/u/fu+FW/slCAGt2AJPwJQ4qB0s9/CNeaLzmdtsPnamxKyXzj0zBUn9r hdkS812uyAQ7ANLtQhi2T3nDUEJmuxPdFOobSMxEMtUBr7jUtnbTJH1o2xsQ X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 27 Jul 2026 07:05:55 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1785150350; bh=3tofWYEtDHo9UWEPeON+mK5N6mW7D2Ci1qy09sWvOIg=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=dg7pjeHOa1BD5kDe/21a4+GtXcHxODNd4Mf79P3JadkkdzQnhLXApTUnAHsEiUHPD zDiSp11mohJe7kfrHReiS8T37sry4mPsl5d+SW/hJEAj5nF3AKRFZk4YoObo2kiKjO doy3QP1wUnN4WZVeoZdp1ZrKFqmm6G5iEKy1gwqoozVrMbItkIWe1RL3d/53BpDZTF N9DRTZuZWysZ+3wAVoYlWUXj2NDbbM4I7KbYGjMEsXmfruQKplYnj+tRUtCIY2Ybdt RQpCmGFkJG+jN8x3eBYgPQwxSjhq4qnzzWXCXAfrsjYzbFdeWdci7jh5Dte3su6WZa VdqtDqvvKQP4w== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id B718AB00076; Mon, 27 Jul 2026 13:05:50 +0200 (CEST) Date: Mon, 27 Jul 2026 13:05:50 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Zsolt Parragi Cc: pgsql-bugs@lists.postgresql.org Subject: Re: REPACK (CONCURRENTLY) doesn't handle invalid indexes Message-ID: 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 Hello, On 2026-Jul-21, Zsolt Parragi wrote: > While testing REPACK, I noticed that REPACK (CONCURRENTLY) fails with > invalid unique indexes, while the non-concurrent version handles them. Thanks for testing! > The attached patch mirrors this handling for CONCURRENTLY: constraints > won't be enforced for invalid indexes. Wouldn't it make more sense to just ignore invalid indexes and not build anything at all for them? -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/