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 1wlq0b-000Peo-0b for pgsql-bugs@arkaria.postgresql.org; Mon, 20 Jul 2026 15:34:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wlq0Y-003zXm-2v for pgsql-bugs@arkaria.postgresql.org; Mon, 20 Jul 2026 15:34:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wlq0Y-003zXd-01 for pgsql-bugs@lists.postgresql.org; Mon, 20 Jul 2026 15:34:18 +0000 Received: from fhigh-a7-smtp.messagingengine.com ([103.168.172.158]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wlq0U-000000018I7-1qO0 for pgsql-bugs@lists.postgresql.org; Mon, 20 Jul 2026 15:34:16 +0000 Received: from phl-compute-09.internal (phl-compute-09.internal [10.202.2.49]) by mailfhigh.phl.internal (Postfix) with ESMTP id 06C66140014A; Mon, 20 Jul 2026 11:34:14 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-09.internal (MEProxy); Mon, 20 Jul 2026 11:34:14 -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=1784561654; x= 1784648054; bh=Vsekg9gzAewg/8esLEuwhUsE4QzIhfOPtHjPgWVVfBE=; b=J PRcqs6U3uAEZVh9Si7oqL+u8hOLqD0vENi0o+crYfsRrNC/Qf2tB9qj80camQjc9 Ky1lAlU8Fcf6DvgGTU/UB4FQg2qcH8osqh+iAxiDku95CP8jj9xtzOElo7o0ZxSB mVvFq2Y2K/xs4uaLMP9li3fLVTZmBzsA2Cv8KgYCEFaZ0NxlsSVxY1gLP7xcW2jZ ifXMFuCGGCsHvm5avVJTDjDRtERJYEC0jaD86iM4FRuAw/02OP77KXt1ZbzECTz9 UjQBGLm03mGk525tcEjiMo23HZ2JT2vYr5sh2bPHhItGwnaV9N2bUHwv4UpSm4jG Gpl9q0jQJ7aXmQ87HqGXw== 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=1784561654; x=1784648054; bh=V sekg9gzAewg/8esLEuwhUsE4QzIhfOPtHjPgWVVfBE=; b=aUyJqdNOs+YALUIEy QThyzmdWL+yGVFvGU1FgDeSKwGB7tqwMo4QafevLM5y8berksu1I0OMz6ctqWR6N 5l2fvnTT7hqD9iVFd2bPl0sndgCkBuXYZWJhKA1J+1zesH1kPigxY1TSOtRTL5pY VdskFmb1hOn0iSRN2WPTuwpkGx0agpSfxKx2dqbcwKH6rzCvdWQHMkhp6HxSEp+7 6t6apdjFDX0OlMBLcykXrx5gfR9itbJKFogOVKNTSSDlHxyTofWu3A85KIOHMEr5 eW1AEt/AkBfCDMH4T4Mbr+D9lO1Froa5GAZAG27SRFbN+bxEFB2lIY0WTPSZFGI+ Ka2Gw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFibTf6XR6sKWtxbNFAt7vnz5ThB7XL7t2qBB0eJvYdezk+iFGIbIO/wXAkBTbFJi JVEVe539UQEC9T1J2GEvDcC27ozdi/xiZPCnLVksnIAbhzEF2CmRjQJVkFXEiUWR+Np+I1 OLxpV6ZoL8/e9/eu35IxSq9XzZc/k9DuVbBpmE4j3/WyhB4DypXqPgKhP5pvDsdf15ZQth SVdxW0E3ei44b+Pu30JsjNxPtR6exPNdhNCwBidagm7ndxWmSbH87n1szKO6caFZitYeiM te3BaREMVkrv5WYqHxhZMSXBYd+qHhRU2bIYnAfflv70TX8bcs8DWjRaPFrFRGkN+ZvzB1 /kJxrUgjnzT9NLunZln69ayD8jypoBMPneZ+Zz4bbp1fQ4OXKohj6Jn2Py7v9RT2c5LRoG wVRJI7mPqO/eGm5egBgtenzlH94O75g4GEPIKfoJAtAE74qcXEa0B+UFlKJsZg5vBo5aUH zLMoV88kGefTPX64pwVvYcG1TUJik9NQjdIDkIzF3IBAPMntg3VdeoG/u0LWq7bmq01xNI 8afMOpKRfRCXt0UUFDKqj1t1QLRn0C0fh0L7Wc4B0DOzWLV3hQVhv/4pM2fZN2BxSCgrM1 OWPj3mGZhYwXWpBdMMxfDSf891x9IGNq56zCGwg1K7QHhf0AElQoine2t27w X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 20 Jul 2026 11:34:13 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1784561651; bh=YXNO64CM4PpecY7SufAqLwoRTSrm5P2EQvWQJ5oiutY=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=YQNqLvw6eJQ6QXCAF/oUFnQ8nDX3HAGa73D9RaTOuZhdMRfnDFh/ya/Lo2fYWSkhq 1MI+mfPu0Ucm2LHkuxc/Yq0bGFQq+qLZAl8YW6fJF7yZWIfbNKstihvHwWGwsFmWQj hsdDCxGxvE269MVc+R7pDdoX+AsgP4mFdZcyiy3t9wAWUZhwuGNoXwRgDz0FUtgpq/ da8hf+UQ6PR2KfcA2sxY0ozC5Iu2k00AKwLhPkZrVTYcU2joweGUvHv17NjKUJnfT1 YchxPU8oO72lVnWGpDLwi6y2unLAcbPK6a4X0ow5rjSdELd4sskyqSMxOpj/6TkC9e O1w2ZJgOdeO1A== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id 0A08CB00009; Mon, 20 Jul 2026 17:34:11 +0200 (CEST) Date: Mon, 20 Jul 2026 17:34:11 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Li Japin Cc: Keith Paskett , "pgsql-bugs@lists.postgresql.org" Subject: Re: =?utf-8?B?5Zue5aSNOiBwZ19yZXN0b3I=?= =?utf-8?Q?e?= error with partitioned table having exclude constraint 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 On 2025-May-14, Li Japin wrote: > Apologies for the delay. Considering it further, ignoring ii_ExclusionProcs and > ii_ExclusionStrats seems incorrect given custom operators. > > I've also updated ii_NumIndexAttrs to ii_NumIndexKeyAttrs, as exclusion indexes > won't exceed the ii_NumIndexKeyAttrs. > > I've also moved the test cases to indexing.sql. I'm unsure of its suitability, but seeing > pg_dump/pg_upgrade tests prompted the move. Thanks for updating it. I agree that adding the tests to indexing.sql is the right move. I have polished the patch a bit more and pushed to branches from 17 onwards. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/