Disallow NULLS NOT DISTINCT indexes for primary keys

Title

Topic

Bug Fixes

Created

2023-02-23 21:07:54

Last modified

2023-02-24 10:23:21 (1 year, 8 months ago)

Latest email

2023-02-23 21:07:10 (1 year, 8 months ago)

Status

2023-03: Committed

Target version

Authors

Daniel Gustafsson (d_gustafsson)

Reviewers

Committer

Daniel Gustafsson (d_gustafsson)

Links

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/4204
git checkout commitfest/cf/4204

Emails

BUG #17720: pg_dump creates a dump with primary key that cannot be restored, when specifying 'using index ...': First at 2022-12-14 09:07:45 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2023-02-23 21:07:10 by Daniel Gustafsson <daniel at yesql.se>
Latest attachment (v4-0001-Disallow-NULLS-NOT-DISTINCT-indexes-for-primary-k.patch) at 2023-02-23 21:07:10 from Daniel Gustafsson <daniel at yesql.se>
    Attachment (v4-0001-Disallow-NULLS-NOT-DISTINCT-indexes-for-primary-k.patch) at 2023-02-23 21:07:10 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v3-0001-Disallow-NULLS-NOT-DISTINCT-indexes-for-primary-k.patch) at 2022-12-16 16:03:15 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v2-0001-Disallow-NULLS-NOT-DISTINCT-indexes-for-primary-k.patch) at 2022-12-15 13:18:05 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v1-0001-Disallow-NULLS-NOT-DISTINCT-indexes-for-primary-k.patch) at 2022-12-14 22:30:54 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (pg_dump_pk_nulls.diff) at 2022-12-14 13:02:40 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)

History

When	Who	What
2023-02-24 10:23:21	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-03 with status: Committed
2023-02-24 10:23:21	Daniel Gustafsson (d_gustafsson)	Changed committer to d_gustafsson
2023-02-23 21:08:07	Daniel Gustafsson (d_gustafsson)	Changed authors to Daniel Gustafsson (d_gustafsson)
2023-02-23 21:08:07	Daniel Gustafsson (d_gustafsson)	Changed targetversion to 16
2023-02-23 21:07:55	Daniel Gustafsson (d_gustafsson)	Attached mail thread 17720-dab8ee0fa85d316d@postgresql.org
2023-02-23 21:07:54	Daniel Gustafsson (d_gustafsson)	Created patch record