support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint

Edit
ID 5645
Title support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 1, First patch: +57−27, All patches: +57−27
Tags
Created 2025-03-11 07:25:09
Last modified 2026-02-01 00:00:09 (2 weeks ago)
Latest email 2026-01-21 19:26:14 (4 weeks ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version
Authors Jian He (stayreal)
Reviewers Matheus Alcantara (matheus.alcantara)Become reviewer
Committer Peter Eisentraut (petere)
Links
Emails
support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
First at 2025-03-11 04:17:36 by jian he <jian.universality at gmail.com>
Latest at 2026-01-21 19:26:14 by Matheus Alcantara <matheusssilv97 at gmail.com>
Latest attachment (v5-0001-Allow-ALTER-COLUMN-SET-EXPRESSION-on-virtual-columns-with-CHECK-c.patch) at 2026-01-21 05:10:20 from jian he <jian.universality at gmail.com>
    Attachment (v5-0001-Allow-ALTER-COLUMN-SET-EXPRESSION-on-virtual-columns-with-CHECK-c.patch) at 2026-01-21 05:10:20 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Allow-ALTER-COLUMN-SET-EXPRESSION-on-virtual-columns-with-CHECK-c.patch) at 2026-01-19 16:11:48 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Allow-ALTER-COLUMN-SET-EXPRESSION-on-virtual-columns-with-CHECK-c.patch) at 2026-01-15 04:31:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (test-no-table-rewrite.diff.nocfbot) at 2026-01-14 21:01:58 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-allow-change-generated-expression-while-check-constraint-.patch) at 2025-07-07 02:24:13 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-generated-column-set-expression-with-check-constraint.patch) at 2025-04-24 02:42:31 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-virtual-generated-column-set-expression-with-check-constr.patch) at 2025-03-11 04:17:36 from jian he <jian.universality at gmail.com> (Patch: Yes)
History
When Who What
2026-02-19 04:45:51 Soumya S Murali (soumyamurali) Removed soumyamurali from reviewers
2026-02-19 04:44:47 Soumya S Murali (soumyamurali) Added soumyamurali as reviewer
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-22 12:40:30 Peter Eisentraut (petere) Added petere as committer
2026-01-20 15:55:37 Matheus Alcantara (matheus.alcantara) Added matheus.alcantara as reviewer
2025-12-03 08:56:39 Jian He (stayreal) Moved from CF PG19-3 to CF PG19-4
2025-10-09 16:12:24 Jian He (stayreal) Moved from CF PG19-2 to CF PG19-3
2025-08-31 16:21:01 Peter Eisentraut (petere) Moved from CF PG19-1 to CF PG19-2
2025-07-07 02:41:24 CFbot Patch does not need rebase anymore
2025-06-29 15:10:45 CFbot Patch needs rebase
2025-03-11 07:25:10 Jian He (stayreal) Attached mail thread CACJufxH3VETr7orF5rW29GnDk3n1wWbOE3WdkHYd3iPGrQ9E_A@mail.gmail.com
2025-03-11 07:25:09 Jian He (stayreal) Created patch record
Edit