| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | Shayon Mukherjee <shayonj(at)gmail(dot)com> |
| Cc: | Benoit Lobréau <benoit(dot)lobreau(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>, Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) |
| Date: | 2025-02-08 05:40:52 |
| Message-ID: | CACJufxGWoA3_hfESU9u+YFMHCNxxcoJqiBcDk=7dfFO12bfS9w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| Attachment | Content-Type | Size |
|---|---|---|
| v11-0001-minor-indentation-changes.no-cfbot | application/octet-stream | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2025-02-08 06:47:23 | proposal - plpgsql - support standard syntax for named arguments for cursors |
| Previous Message | Sami Imseih | 2025-02-08 04:55:23 | Re: Proposal to CREATE FOREIGN TABLE LIKE |