Alow ALTER COLUMN TYPE when dependent generated column has SET EXPRESSION

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +130−21, All patches: +130−21

Topic

Server Features

Tags

Created

2025-10-21 07:13:37

Last modified

2025-11-12 00:02:11 (3 hours ago)

Latest email

2025-10-22 08:57:37 (2 weeks ago)

Status

PG19-4 (2026-01-01 – 2026-01-31): Needs review

PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF

Target version

Authors

Chao Li (chaol)

Reviewers

Committer

Links

Emails

Why cannot alter a column's type when it's used by a generated column: First at 2025-10-17 02:04:11 by Chao Li <li.evan.chao at gmail.com>
Latest at 2025-10-22 08:57:37 by Chao Li <li.evan.chao at gmail.com>
Latest attachment (v2-0001-Alow-ALTER-COLUMN-TYPE-when-dependent-generated-c.patch) at 2025-10-22 08:57:37 from Chao Li <li.evan.chao at gmail.com>
    Attachment (v2-0001-Alow-ALTER-COLUMN-TYPE-when-dependent-generated-c.patch) at 2025-10-22 08:57:37 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Alow-ALTER-COLUMN-TYPE-when-dependent-generated-c.patch) at 2025-10-21 07:03:41 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v1-0001-SET-DATA-TYPE-cope-with-generation-expression-dependency.patch) at 2025-10-20 07:51:11 from jian he <jian.universality at gmail.com> (Patch: Yes)

History

When	Who	What
2025-11-12 00:02:11	Chao Li (chaol)	Moved from CF PG19-3 to CF PG19-4
2025-10-21 07:13:38	Chao Li (chaol)	Attached mail thread A61F14F6-339D-46EF-9FC1-A8438FE3BE86@gmail.com
2025-10-21 07:13:37	Chao Li (chaol)	Created patch record