skip check constraints verification for unaffected columns during UPDATE

Edit
ID 6270
Title skip check constraints verification for unaffected columns during UPDATE
CI (CFBot) Summary
Stats (from CFBot) Patch version: v7, Patch count: 1, First patch: +259−17, All patches: +259−17
Tags
Created 2025-12-02 08:00:14
Last modified 2026-04-15 00:46:45 (3 weeks ago)
Latest email 2026-03-07 09:46:23 (2 months ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
Target version 19
Authors Jian He (stayreal)
Reviewers Florin Irion (irionr) Become reviewer
Committer
Links
Emails
UPDATE run check constraints for affected columns only
First at 2025-12-01 06:20:32 by jian he <jian.universality at gmail.com>
Latest at 2026-03-07 09:46:23 by jian he <jian.universality at gmail.com>
Latest attachment (v7-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch) at 2026-03-07 09:46:23 from jian he <jian.universality at gmail.com>
    Attachment (v7-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch) at 2026-03-07 09:46:23 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch) at 2026-03-06 02:17:35 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v5-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch) at 2026-03-05 03:12:04 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch) at 2026-03-04 01:04:49 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch) at 2026-01-23 02:09:27 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-UPDATE-run-check-constraints-for-affected-columns-only.patch) at 2025-12-07 15:50:37 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-UPDATE-run-check-constraints-for-affected-columns-only.patch) at 2025-12-01 06:20:32 from jian he <jian.universality at gmail.com> (Patch: Yes)
History
When Who What
2026-04-15 00:46:45 Jian He (stayreal) Moved from CF PG19-Final to CF PG20-1
2026-03-04 16:02:23 Florin Irion (irionr) Added irionr as reviewer
2026-03-03 15:04:04 Jian He (stayreal) Changed name to skip check constraints verification for unaffected columns during UPDATE
2026-02-01 00:00:08 CFbot Moved from CF PG19-4 to CF PG19-Final
2025-12-02 08:00:14 Jian He (stayreal) Attached mail thread CACJufxEtY1hdLcx=Fhnqp-ERcV1PhbvELG5COy_CZjoEW76ZPQ@mail.gmail.com
2025-12-02 08:00:14 Jian He (stayreal) Created patch record
Edit