Fix not reset pg_attribute.attnotnull when PK drop indirectly

4911

Title

Topic

Bug Fixes

Created

2024-04-02 12:47:50

Last modified

2024-04-23 09:02:05 (6 months, 4 weeks ago)

Latest email

2024-04-19 10:40:11 (7 months 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