Fix bug of CHECK constraint enforceability recursion

Title

CI (CFBot)

Needs rebase! Needs rebase since 4 months. Failing since 4 months.
Additional links previous successfully applied patch (outdated):

Stats (from CFBot)

Unknown

Tags

Bugfix DDL

Created

2026-06-02 08:06:35

Last modified

2026-06-28 22:03:13 (4 months ago)

Latest email

2026-06-17 07:22:44 (4 months ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Committed

Target version

Authors

Chao Li (chaol)

Reviewers

Zsolt Parragi (zsolt.parragi) Log in to become reviewer

Committer

Andrew Dunstan (adunstan)

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-17 07:22:44 by Chao Li <li.evan.chao at gmail.com>
Latest attachment (v11-0001-Prevent-inherited-CHECK-constraints-from-being-w.patch) at 2026-06-17 07:22:44 from Chao Li <li.evan.chao at gmail.com>
    Attachment (v11-0001-Prevent-inherited-CHECK-constraints-from-being-w.patch) at 2026-06-17 07:22:44 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v10-0001-misc-refactor-ATCheckCheckConstrHasEnforcedParent.nocfbot) at 2026-06-17 03:27:31 from jian he <jian.universality at gmail.com> (Patch: Yes)
    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-28 22:03:14	Chao Li (chaol)	Closed in commitfest PG20-1 with status: Committed
2026-06-28 22:03:13	Chao Li (chaol)	Changed committer to adunstan
2026-06-28 12:31:32	CFbot	Patch needs rebase
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