Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints

Edit
ID 5554
Title Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
CI (CFBot) Summary
Stats (from CFBot) Patch count: 2, First patch: +18−5, All patches: +1101−106
Topic SQL Commands
Tags
Created 2025-02-07 06:27:34
Last modified 2025-04-07 17:53:53 (6 months ago)
Latest email 2025-04-08 00:21:49 (6 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
Target version 18
Authors Rushabh Lathia (rlathia)
Reviewers Become reviewer
Committer Álvaro Herrera (alvherre)
Links
Emails
Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
First at 2025-02-06 12:38:46 by Rushabh Lathia <rushabh.lathia at gmail.com>
Latest at 2025-04-08 00:21:49 by Rushabh Lathia <rushabh.lathia at gmail.com>
Latest attachment (v8-0003-not-null-not-valid-miscellous-fix.no-cfbot) at 2025-04-07 12:43:03 from jian he <jian.universality at gmail.com>
    Attachment (v8-0003-not-null-not-valid-miscellous-fix.no-cfbot) at 2025-04-07 12:43:03 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0002-Remove-attnotnullvalid-again.patch) at 2025-04-07 08:28:22 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Allow-NOT-NULL-constraints-to-be-added-as-NOT-VAL.patch) at 2025-04-06 18:02:35 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v7-0002-NOT-NULL-NOT-VALID.patch) at 2025-04-05 07:29:55 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-MergeWithExistingConstraint.patch) at 2025-04-04 11:54:37 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (scratch96.sql) at 2025-04-03 07:45:43 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v6-0001-ensure-pg_dump-table-constraint-info-remain-the-s.patch) at 2025-04-02 13:51:31 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-NOT-NULL-NOT-VALID.patch) at 2025-04-02 11:48:04 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (v6-0001-NOT-NULL-NOT-VALID.patch) at 2025-04-01 20:22:26 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (notnull-notvalid.patch) at 2025-03-27 19:25:40 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v5-0001-NOT-NULL-NOT-VALID.patch) at 2025-03-24 01:27:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-NOT-NULL-NOT-VALID.patch) at 2025-03-21 14:36:32 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-NOT-NULL-NOT-VALID.patch) at 2025-03-20 14:59:28 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0002-Support-for-pg_dump.patch) at 2025-03-20 09:54:45 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-Throw-warning-if-NOT-VALID-is-given-during-CREATE-TA.patch) at 2025-03-17 11:23:25 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v2-0001-not-null-not-valid-implementation.patch) at 2025-03-17 11:14:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Convert-pg_attribut.attnotnull-to-char-type.patch) at 2025-03-12 10:22:38 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0002-Support-NOT-VALID-and-VALIDATE-CONSTRAINT-for-named-.patch) at 2025-03-11 10:15:46 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0004-Adjust-set_attnotnull-API-input-parameters.patch) at 2025-03-10 11:26:14 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-Convert-pg_attribut.attnotnull-to-char-type.patch) at 2025-02-27 09:55:51 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-fixup.patch.txt) at 2025-02-21 06:13:39 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0004-Documentation-and-tab-complete-for-the-NOT-NULL-NOT-.patch) at 2025-02-12 11:22:36 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-Convert-pg_attribut.attnotnull-to-char-type.patch) at 2025-02-10 17:18:57 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0003-Support-pg_dump-to-dump-NOT-VALID-named-NOT-NULL-con.patch) at 2025-02-06 12:38:46 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
History
When Who What
2025-04-07 17:53:53 Álvaro Herrera (alvherre) Closed in commitfest 2025-03 with status: Committed
2025-04-02 14:04:38 CFbot Patch does not need rebase anymore
2025-04-02 12:05:52 CFbot Patch needs rebase
2025-04-01 21:19:44 CFbot Patch does not need rebase anymore
2025-03-30 08:32:43 CFbot Patch needs rebase
2025-03-27 19:39:43 CFbot Patch does not need rebase anymore
2025-03-27 13:31:52 vigneshwaran C (vignesh.postgres) New status: Needs review
2025-03-26 23:17:39 CFbot Patch needs rebase
2025-03-11 10:32:51 CFbot Patch does not need rebase anymore
2025-03-11 04:15:43 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-10 11:33:32 CFbot Patch needs rebase
2025-02-07 06:29:01 Rushabh Lathia (rlathia) Changed authors to Rushabh Lathia (rlathia)
2025-02-07 06:29:01 Rushabh Lathia (rlathia) Changed committer to alvherre
2025-02-07 06:29:01 Rushabh Lathia (rlathia) Changed targetversion to 18
2025-02-07 06:27:34 Rushabh Lathia (rlathia) Attached mail thread CAGPqQf0KitkNack4F5CFkFi-9Dqvp29Ro=EpcWt=4_hs-Rt+bQ@mail.gmail.com
2025-02-07 06:27:34 Rushabh Lathia (rlathia) Created patch record
Edit