Re: support create index on virtual generated column.

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: Peter Eisentraut <peter(at)eisentraut(dot)org>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: support create index on virtual generated column.
Date: 2026-05-06 09:20:15
Message-ID: CALdSSPh7E2MzTxg2QUE7E3FbdUkqVFCjtSQOdg9=rpSzPQsXcg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

That needed rebase since 570e2fcc041a, so PFA.

For v8:

> stmt->whereClause =
> expand_generated_columns_in_expr(stmt->whereClause, rel, 1);

Maybe add at least an assertion stmt->whereClause != NULL, like the
one we already do in ComputeIndexAttrs?

--
Best regards,
Kirill Reshke

Attachment Content-Type Size
v1-0001-index-on-virtual-generated-column.patch application/octet-stream 17.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-05-06 09:25:38 Re: COPY JSON: use trailing commas in FORCE_ARRAY output
Previous Message Chao Li 2026-05-06 09:18:38 Re: COPY JSON: use trailing commas in FORCE_ARRAY output