Fix not reset pg_attribute.attnotnull when PK drop indirectly

Edit
ID 4911
Title Fix not reset pg_attribute.attnotnull when PK drop indirectly
Topic Bug Fixes
Created 2024-04-02 12:47:50
Last modified 2024-04-23 09:02:05 (7 months, 2 weeks ago)
Latest email 2024-04-19 10:40:11 (7 months, 3 weeks ago)
Status
2024-07: Committed
Target version
Authors Tender Wang (tndrwang)
Reviewers Álvaro Herrera (alvherre), jian he (universality)Become reviewer
Committer Álvaro Herrera (alvherre)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4911
git checkout commitfest/cf/4911
Emails
Can't find not null constraint, but \d+ shows that
First at 2024-03-26 12:00:36 by Tender Wang <tndrwang at gmail.com>
Latest at 2024-04-19 10:40:11 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (v2-0001-Better-handle-indirect-constraint-drops.patch) at 2024-04-18 18:49:52 from Alvaro Herrera <alvherre at alvh.no-ip.org>
    Attachment (v2-0001-Better-handle-indirect-constraint-drops.patch) at 2024-04-18 18:49:52 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Better-handle-indirect-constraint-drops.patch) at 2024-04-11 14:48:00 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v2-0001-Handle-ALTER-.-DROP-NOT-NULL-when-no-pg_constrain.patch) at 2024-04-10 17:23:25 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v1-0001-minor-coesmetuic-refactor-in-dropconstraint_inter.patch) at 2024-04-10 15:03:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Handle-ALTER-.-DROP-NOT-NULL-when-no-pg_constraint-r.patch) at 2024-04-10 13:58:49 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Correctly-reset-attnotnull-when-constraints-dropped-.patch) at 2024-04-09 17:29:03 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v4-0001-Fix-pg_attribute-attnotnull-not-reset-when-droppe.patch) at 2024-03-28 12:05:04 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-pg_attribute-attnotnull-not-reset-when-droppe.patch) at 2024-03-27 14:26:10 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-attnotnull-not-correct-reset-issue.patch) at 2024-03-26 12:00:36 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
History
When Who What
2024-04-23 09:02:05 Tender Wang (tndrwang) Closed in commitfest 2024-07 with status: Committed
2024-04-23 09:02:05 Tender Wang (tndrwang) Changed committer to alvherre
2024-04-02 12:48:50 Tender Wang (tndrwang) Changed reviewers to Álvaro Herrera (alvherre), jian he (universality)
2024-04-02 12:48:50 Tender Wang (tndrwang) Changed authors to Tender Wang (tndrwang)
2024-04-02 12:47:50 Tender Wang (tndrwang) Attached mail thread CAHewXN=hMbNa3d43NOR=OCgdgpTt18S-1fmueCoEGesyeK4bqw@mail.gmail.com
2024-04-02 12:47:50 Tender Wang (tndrwang) Created patch record
Edit