Horton

Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch)

jian he <jian.universality@gmail.com>

View thread
From: jian he <jian.universality@gmail.com>
To: Shayon Mukherjee <shayonj@gmail.com>
Cc: Benoit Lobréau <benoit.lobreau@gmail.com>, Sami Imseih <samimseih@gmail.com>, Michail Nikolaev <michail.nikolaev@gmail.com>, David Rowley <dgrowleyml@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-02-08T05:40:52Z
Lists: pgsql-hackers

Attachments

hi.
```
drop table if exists idxpart;
create table idxpart (a int, b int, c text) partition by range (a);
create table idxpart1 (like idxpart);
alter table idxpart attach partition idxpart1 for values from (0) to (10);

create index idxpart_c on only idxpart (c) invisible;
create index idxpart1_c on idxpart1 (c);

alter index idxpart_c attach partition idxpart1_c;
```
In this case, should ALTER INDEX ATTACH PARTITION change the attached
partition(idxpart1_c)'s "visible" status?


attached is a minor patch about indentation change and meson.build change.