Re: support create index on virtual generated column.

X-MAN <44973863@qq.com>

From: ZizhuanLiu X-MAN <44973863@qq.com>

To: jian he <jian.universality@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>

Cc: Corey Huinker <corey.huinker@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, chengpeng_yan <chengpeng_yan@outlook.com>, guofenglinux <guofenglinux@gmail.com>, 我自己的邮箱 <44973863@qq.com>

Date: 2026-07-07T13:40:10Z

Lists: pgsql-hackers

Attachments

v4-0001-enhance-index-support-for-virtual-generated-colum.patch (application/octet-stream) patch v4-0001

Hi everyone,

This is the V4 patch. On top of prior revisions, I've revised generated_virtual.sql
together with its matching output file generated_virtual.out.

The modifications target index constraints, regular indexes, and foreign keys.

I have uncommented the existing test SQL for these modules and added a few
extra test cases.  All tests are passing successfully.

regards,
--
ZizhuanLiu (X-MAN) 
44973863@qq.com

Commits

Virtual generated columns
- 83ea6c54025b 18.0 cited