[PG19]Three bugs with a CHECK constraint that only the child enforces

Edit
ID 7426
Title [PG19]Three bugs with a CHECK constraint that only the child enforces
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 3, First patch: +73−0, All patches: +296−4
Tags Bugfix
Created 2026-10-10 05:19:09
Last modified 2026-10-10 05:19:09 (2 weeks ago)
Latest email 2026-10-29 05:05:55 (yesterday)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version 19
Authors shihao zhong (zhong950419)
Reviewers Become reviewer
Committer
Links
Emails
[PG19] Three bugs with a CHECK constraint that only the child enforces
First at 2026-10-09 04:42:29 by shihao zhong <zhong950419 at gmail.com>
Latest at 2026-10-29 05:05:55 by jian he <jian.universality at gmail.com>
Latest attachment (v5-0001-Reject-enforcing-a-parent-CHECK-over-a-NOT-VALID-.patch) at 2026-10-24 04:00:00 from shihao zhong <zhong950419 at gmail.com>
    Attachment (v5-0001-Reject-enforcing-a-parent-CHECK-over-a-NOT-VALID-.patch) at 2026-10-24 04:00:00 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (v4-0001-Reject-enforcing-a-parent-CHECK-over-a-NOT-VALID-child.txt) at 2026-10-19 07:06:59 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v3-0001-Preserve-child-constraint-property-in-ALTER-TYPE-and-SET-EXPRESSION.txt) at 2026-10-16 08:16:17 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v2-0002-Keep-a-child-s-ENFORCED-CHECK-when-the-parent-s-c.patch) at 2026-10-15 03:48:46 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (v2-0001-pg_dump-keep-child-table-CHECK-constraint-status.txt) at 2026-10-12 08:44:08 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v1-0003-pg_dump-keep-ENFORCED-on-a-child-s-inherited-CHEC.patch) at 2026-10-09 12:25:03 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
History
When Who What
2026-10-10 05:19:09 shihao zhong (zhong950419) Attached mail thread CAGRkXqSGE=fQrjCoNQsyiCZRKfQ4SrB015CAR=3pXYB5tB=ieg@mail.gmail.com
2026-10-10 05:19:09 shihao zhong (zhong950419) Created patch record
Edit