Fix bug of CHECK constraint enforceability recursion

Edit
ID 6827
Title Fix bug of CHECK constraint enforceability recursion
CI (CFBot) Summary
Stats (from CFBot) Patch version: v10, Patch count: 3, First patch: +385−25, All patches: +416−41
Tags Bugfix DDL
Created 2026-06-02 08:06:35
Last modified 2026-06-02 08:06:35 (2 weeks ago)
Latest email 2026-06-09 00:32:19 (1 week ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version 19
Authors Chao Li (chaol)
Reviewers Zsolt Parragi (zsolt.parragi) Become reviewer
Committer
Links
Emails
Fix bug of CHECK constraint enforceability recursion
First at 2026-05-26 03:51:11 by Chao Li <li.evan.chao at gmail.com>
Latest at 2026-06-09 00:32:19 by Chao Li <li.evan.chao at gmail.com>
Latest attachment (v10-0001-Prevent-inherited-CHECK-constraints-from-being-w.patch) at 2026-06-09 00:32:19 from Chao Li <li.evan.chao at gmail.com>
    Attachment (v10-0001-Prevent-inherited-CHECK-constraints-from-being-w.patch) at 2026-06-09 00:32:19 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-06-08 11:51:33 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Minor-refactoring-for-v8.nocfbot) at 2026-06-08 10:28:55 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-06-06 03:06:00 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-06-03 22:17:09 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-06-03 08:17:24 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (checkconstr_inheritance_issue.nocfbot) at 2026-06-03 06:58:45 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-06-02 06:39:21 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-06-02 06:24:01 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Prevent-inherited-CHECK-constraints-from-being-weakened.patch) at 2026-06-01 15:51:54 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-05-28 22:56:22 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Prevent-inherited-CHECK-constraints-from-being-we.patch) at 2026-05-27 06:20:21 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v1-0001-disallow-alter-enforciability-of-inherited-check-constraint.patch) at 2026-05-26 08:32:29 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-CHECK-constraint-enforceability-recursion.patch) at 2026-05-26 05:48:02 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-CHECK-constraint-enforceability-recursion.patch) at 2026-05-26 03:51:11 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
History
When Who What
2026-06-06 20:47:29 Zsolt Parragi (zsolt.parragi) Added zsolt.parragi as reviewer
2026-06-02 08:06:35 Chao Li (chaol) Attached mail thread E74C57FA-1DD0-4C8E-8FB1-538034752592@gmail.com
2026-06-02 08:06:35 Chao Li (chaol) Created patch record
Edit