Horton
Menu

Re: [PATCH] Fix: Partitioned parent index remains invalid after child indexes are repaired

Michael Paquier <michael@paquier.xyz>

View thread
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
Date: 2026-04-30T23:28:06Z
Lists: pgsql-hackers 
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:
> 
> "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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. doc: Mention validation attempt during ALTER INDEX .. ATTACH PARTITION

  2. Allow ALTER INDEX .. ATTACH PARTITION to validate a parent index