Re: support create index on virtual generated column.

2025-04-15 Thread jian he
On Mon, Apr 14, 2025 at 8:05 PM Kirill Reshke wrote: > > On Mon, 14 Apr 2025 at 16:10, jian he 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 ta

Re: support create index on virtual generated column.

2025-04-14 Thread Kirill Reshke
On Mon, 14 Apr 2025 at 16:10, jian he 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 ch

Re: support create index on virtual generated column.

2025-04-14 Thread jian he
On Wed, Mar 26, 2025 at 5:36 PM Kirill Reshke wrote: > reshke=# CREATE TABLE xx (a int, b int GENERATED ALWAYS AS (a * 2) VIRTUAL) ; > CREATE TABLE > reshke=# create index on xx (b); > CREATE INDEX > reshke=# > reshke=# \d+ xx > Table "public.xx

Re: support create index on virtual generated column.

2025-03-26 Thread Kirill Reshke
On Wed, 26 Mar 2025 at 12:15, jian he wrote: > > hi. > attached patch for implementing $subject feature. > > * internally such index will be transformed into expression index. > for example, an index on (b int GENERATED ALWAYS AS (a * 2) VIRTUAL) will be > converted into an expression index on