Create unique GiST index

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v1, Patch count: 1, First patch: +447−17, All patches: +447−17

Topic

SQL Commands

Tags

Bugfix

Created

2025-12-31 22:58:58

Last modified

2026-01-02 18:31:16 (1 week ago)

Latest email

2026-01-02 07:19:50 (1 week ago)

Status

PG19-4 (2026-01-01 – 2026-01-31): Needs review

Target version

Authors

Paul Jungwirth (pjungwir)

Reviewers

Committer

Links

Emails

BUG #19098: Can't create unique gist index, where pg_indexes says that WITHOUT OVERLAPS does exacly that: First at 2025-10-29 09:54:24 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-01-02 18:32:58 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest attachment (v1-0001-Allow-unique-GiST-indexes.patch) at 2025-12-31 22:47:42 from Paul A Jungwirth <pj at illuminatedcomputing.com>
Attachment (v1-0001-Allow-unique-GiST-indexes.patch) at 2025-12-31 22:47:42 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
Attachment (v1-0001-Fix-pg_get_indexdef-for-temporal-constraints.patch) at 2025-10-29 13:52:38 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
Create unique GiST indexes: First at 2025-12-31 22:55:13 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest at 2026-01-02 18:39:52 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest attachment (v1-0001-Allow-unique-GiST-indexes.patch) at 2025-12-31 22:55:13 from Paul A Jungwirth <pj at illuminatedcomputing.com>
Attachment (v1-0001-Allow-unique-GiST-indexes.patch) at 2025-12-31 22:55:13 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)

History

When	Who	What
2026-01-02 18:31:16	Paul Jungwirth (pjungwir)	Attached mail thread CA+renyUKo9GC+btg07E2Dt8998kWxSvM-4z16jUA7SOxDcJ9OQ@mail.gmail.com
2025-12-31 22:58:58	Paul Jungwirth (pjungwir)	Attached mail thread [email protected]
2025-12-31 22:58:58	Paul Jungwirth (pjungwir)	Created patch record