Feedback-ID: i0fe9450f:Fastmail
Date: Fri, 1 May 2026 08:28:06 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Mohamed ALi <moali.pg@gmail.com>
Cc: Sami Imseih <samimseih@gmail.com>, Haibo Yan <tristan.yim@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: [PATCH] Fix: Partitioned parent index remains invalid after
 child indexes are repaired
Message-ID: <afPlhhHece0pr2Wd@paquier.xyz>
References: 
 <CABXr29GbJe7-vbm0Fn=HWx3vQonwFtv_zO1pSc5FZAvjLuUDVA@mail.gmail.com>
 <CABXr29Epj=23eYAWg_mTdiXYQQzJSVN22uk6tK8ei0ts5wXvSQ@mail.gmail.com>
 <CAA5RZ0s16eHrzcDupipAxC++e-p_n_M7Fpg-MG-V59fB=wykLw@mail.gmail.com>
 <ad1rubGPdHxNnDh5@paquier.xyz>
 <ad5l0sGiJwdkXI-L@paquier.xyz>
 <CAA5RZ0uM7_YPdSahGh1sGeewMb9SzKswyLaZty8aR+a7XpQydQ@mail.gmail.com>
 <aeVSPx7F3ghkZugb@paquier.xyz>
 <aegozMN-abH3ki-P@paquier.xyz>
 <CAA5RZ0sQfnLyv2Ta-r6y==QwwUr+M0BxVbK0=0_HZZA1ywc3Bw@mail.gmail.com>
 <CAGnOmWpHu25_LpT=zv7KtetQhqV1QEZzFYLd_TDyOLu1Od9fpw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="7URjRZI9kFnNgz5h"
Content-Disposition: inline
In-Reply-To: 
 <CAGnOmWpHu25_LpT=zv7KtetQhqV1QEZzFYLd_TDyOLu1Od9fpw@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/afPlhhHece0pr2Wd%40paquier.xyz>
Precedence: bulk


--7URjRZI9kFnNgz5h
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 29, 2026 at 02:36:09PM -0700, Mohamed ALi wrote:
> I have attached a small doc-only patch that adds a paragraph to the
> ALTER INDEX documentation:
>=20
> "If the named index is already attached to the altered index, the
> command will attempt to validate the parent index if the parent
> is currently invalid."

That sounds like a good idea to me to mention this behavior in the
docs, as you are suggesting.  That's less guesses a user would need to
do, just more reading and something we can directly point at.
--
Michael

--7URjRZI9kFnNgz5h
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnz5YYACgkQnvQgOdby
QH33ew//cK3hmHmTBAC9cB+0qWFL03FIwGN23aYI0ibZFUi97CzWUlYVvP/epMHM
jULyfwzzD7TIQMYgkePDBxvxyNc7aKCyvDVG/l4MxbdrLVjZwUIPzFw6NIUeRy/3
oLzJWuJmK2rANvJtHzMkGlCkIX/iUplyX1H18JokNhGn20Mg+9RrbGz8RPfluYhP
6YRL3XtAXrSDx30KHEwpfbDIhyPS2gl0ffU7M7ZX/1MXac9nqqg10HDCbBR+afQc
gbTKYetFgXlfUP9EOrJRe1QHbnTMcFIwEzjp2trJtSPE0kKgXYiOsptKq699wQhi
TKCaEHZf7DhyXid/jzh0I8R5R8Jg+fLsS3sM9bOgwzGFe9G2sqcc7sD/7PCLAXHV
FjPR/sv5JoMGSY55QB3fB75UzwLmF8l8/JRuBQ0xieL/K2+ggiwcXmtW2xS21l+7
KgzzfGRtLzk0FC2kvoLePKAT2QbmL2B6hoCZJcSepg305FEKNVtax8IZgaZDYY4P
FDIzNu8mDHfe1iDJNCGLEpFGNoscSS4N4xGhosGYKRr9BW6eXIBhCiZHN4R+0okh
dQEl5NOVLAlXpQ8e+p7RUq9cdH4zXbZwoRJjMyB16dcr8qxXevcoPKEBpt6yRGJ1
RP4kCDRQIbpmsJMg1DmDVy1+65rqfaf0e39Zcfsp773rl7ma6a8=
=gTf0
-----END PGP SIGNATURE-----

--7URjRZI9kFnNgz5h--