Re: [PATCH] doc: Document that invalid indexes are skipped during ATTACH PARTITION

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Mohamed ALi <moali(dot)pg(at)gmail(dot)com>
Cc: Sami Imseih <samimseih(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] doc: Document that invalid indexes are skipped during ATTACH PARTITION
Date: 2026-06-23 07:53:49
Message-ID: ajo7jXnW5tnX9V3V@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 03, 2026 at 04:27:18PM +0900, Michael Paquier wrote:
> Hmm. How about?
> For each index in the target table, if a valid equivalent index
> already exists in the partition, it will be attached to the target
> table's index, as if ALTER INDEX ATTACH PARTITION had been executed;
> otherwise, a new corresponding index will be created. Invalid indexes
> on the partition are skipped.

Took me some time to get back to this one. I have reused my previous
wording, applied it down to v14.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-06-23 08:13:43 Re: psql: Fix CREATE SCHEMA scanning of nested routine bodies
Previous Message Jeevan Chalke 2026-06-23 07:48:52 Add PRODUCT() aggregate function