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.94.2) (envelope-from ) id 1rDQ47-001xpi-5x for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Dec 2023 14:18:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rDQ45-00EwZY-RH for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Dec 2023 14:18:21 +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.94.2) (envelope-from ) id 1rDQ45-00EwZQ-Ip for pgsql-bugs@lists.postgresql.org; Wed, 13 Dec 2023 14:18:21 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rDQ43-00ACjU-76 for pgsql-bugs@lists.postgresql.org; Wed, 13 Dec 2023 14:18:20 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id E8D623200B95; Wed, 13 Dec 2023 09:18:17 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Wed, 13 Dec 2023 09:18:18 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1702477097; x=1702563497; bh=qaGw1UamlA AW/6ifHSLrr2Xh/qU/Uhd0H9HGDRXz8AA=; b=MWyYX3DlAU7R91Ii9sFw9FxWRR +SgAOvdpgYCH3P+i0N5R9GzN3yeAAUJIpxkx7fgkALGI7FZFpVH1wJNwDfQpNGEc dI3HA7+2LtnblgkOtVLfUumLobqxMejNctDoE7fMTFpL5jdAXZI/YwdGb0nHE44z Y0gXUjcWoN7/Nx5Qb8F5Y4M0y17M1XBVpXazCeQYP8yHVNb7VJbQkS6y9txSgjuO Zsb+BJUdgOED4EGA5sdG2vAr7q+vGajK2n6FLa8Tw4z1EXE40yqdXbYj7fkqtCrX hNEaOPteQanl0/nWoCSRSvz26UVoBm3iY175SyzA2gn+39kyr6tnfWvAlzbA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1702477097; x=1702563497; bh=qaGw1UamlAAW/6ifHSLrr2Xh/qU/ Uhd0H9HGDRXz8AA=; b=NYafPZlq3V2SsZILGefeU5NGC7Y+bt7PsT2bHJZcUT1u KQRWS2zGTyrXhr1jhGKBU1B6EWtoZ6qyVhhl6OXyd+FlvWvXTes1d7tf5/bENnzI kD7vxueMYzwJ2+jHElWwBhqKvLsTOw9uXD+QdYDoIxZNZ6TgDZH6t4HZlFWLP5dx 8vlhe3tKvBw1DNpx9/b0I55qsto7IU333K1e1ikDyRQZ//Igg7Gv5jBlJbSPf4oY 5QyHY+GZo6AJlEeyWRBjIn6F/uKyNhtBk5BhA1mOzZyDT3vEjECtYvKIOl5lzsyP 2MmskPmC1Xxf/nwLQkRK5aciCL8SuP0dcNm9LRWMvw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudeljedgtddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpedvgeduuefhtdeuleettdevjeehheeiveeuieegleetgeeljeelieeuieehgeevhfen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthh grvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 13 Dec 2023 09:18:16 -0500 (EST) Date: Wed, 13 Dec 2023 15:18:14 +0100 From: Michael Paquier To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18246: pgstathashindex() attempts to read invalid file for hash index attached to partitioned table Message-ID: References: <18246-f4d9ff7cb3af77e6@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="Me5Oh+bVkRZD+AXH" Content-Disposition: inline In-Reply-To: <18246-f4d9ff7cb3af77e6@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Me5Oh+bVkRZD+AXH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Dec 13, 2023 at 09:00:01AM +0000, PG Bug reporting form wrote: > This anomaly can be observed since 8b08f7d48 from 2018-01-19, but IMO the > culprit is e759854a0 from 2017-02-03, which introduced the following > asymmetry in pgstatindex.c: > if (!IS_INDEX(rel) || !IS_BTREE(rel)) > if (!IS_INDEX(rel) || !IS_GIN(rel)) > But: > if (!IS_HASH(rel)) Fun, let's fix that. Would you like to write a patch? -- Michael --Me5Oh+bVkRZD+AXH Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmV5vSYACgkQnvQgOdby QH1s2A//Z51epeRfxeyzF23NdRTwCYVuqm60+De1AFCYBUK+C7Y+KPgULD/2xeNV qEknWU6PJlmC4SKqc0dNQAJyXIG1/fNiye/lGo9pJBhQoP+IbHzk9ppg1LauI31q j7HmMC1dUMN8HzWsfMtuLos60IMzWZpSLDOmliRSDlXzjmrWXbPSd3KlnwxpFSGZ sSdogHIIhSZHVReUFph5FK/S64ABxvjiVV9hQMAn9KX0GHargrMdAGy9BY7jrWnG i2aEnHkvsPMfGaX7OoW1uVb3e8hCsqBS6kp8jd7yZgVHQfEPZIR4Cu4Tdw/ccYKw 6acqU3nbH9WLns8I2i82xCWucjq6F/KK1zDqVFeg0oJzwWfzl4mDgC9lONgecNmz pc0tMUsSCKnWVzCnVSZqal0Lkz/qOXry41smdYrLxxJlMw+JIOptX4Xkv+nIV6LN 7x4RWqs7WMjsfsaFynqPIxYNNstgjKnJPU1uCiCzMXsDy7wLiN3np+Iul6MizPUg Qfm/VOYkYwsGW5vZza4q3NowVYMWhip6NrrD+LeNe6DurLbyJq1I5lbEzCFAC4XM YnSXaUuW/ZCn8GecrIWNwxoin7P4VHqhQJ97ZOohIukMAibAwZF0fsApz4Qdvu5H rNZyYGYfiXDRrNeKkgYfaQhtWmX13sRFQ8BIixvup8rtQJWPZb4= =fuo8 -----END PGP SIGNATURE----- --Me5Oh+bVkRZD+AXH--