Re: support create index on virtual generated column.
От | Kirill Reshke |
---|---|
Тема | Re: support create index on virtual generated column. |
Дата | |
Msg-id | CALdSSPiMrRhSyQvAqGxgLMdcmFLrXSDAsCt32pg=e2bh2k4_Tg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: support create index on virtual generated column. (jian he <jian.universality@gmail.com>) |
Ответы |
Re: support create index on virtual generated column.
|
Список | pgsql-hackers |
On Mon, 14 Apr 2025 at 16:10, jian he <jian.universality@gmail.com> wrote: > > new patch attached. Now, > ALTER TABLE DROP COLUMN works fine. > ALTER INDEX ATTACH PARTITION works fine. > creating such an index on a partitioned table works just fine. > for table inheritance: create index on parent table will not cascade > to child table, > so we don't need to worry about this. Hi! I reviewed v2, and it seems to be working now. But there are tests that are comment-out, what is their purpose? I note that commit 83ea6c5 also included some commented tests, so perhaps there's a reason I'm not aware of. ``` ALTER TABLE gtest22c DROP COLUMN e; \d gtest22c -- EXPLAIN (COSTS OFF) SELECT * FROM gtest22c WHERE b * 3 = 6; -- SELECT * FROM gtest22c WHERE b * 3 = 6; -- EXPLAIN (COSTS OFF) SELECT * FROM gtest22c WHERE a = 1 AND b > 0; -- SELECT * FROM gtest22c WHERE a = 1 AND b > 0; ``` -- Best regards, Kirill Reshke
В списке pgsql-hackers по дате отправления: