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

Tags

Bugfix SQL Commands

Created

2025-12-31 22:58:58

Last modified

2026-10-02 03:33:43 (39 minutes ago)

Latest email

2026-03-13 20:29:38 (6 months ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Waiting on Author

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF

PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF

Target version

Authors

Paul Jungwirth (pjungwir)

Reviewers

warda bibi (warda), Prafulla Ranadive (pprandive) Become reviewer

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-03-13 20:29:38 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-10-02 03:33:43	shihao zhong (zhong950419)	Moved from CF PG20-1 to CF PG20-3
2026-04-10 00:00:06	CFbot	Moved from CF PG19-Final to CF PG20-1
2026-03-13 20:29:16	Paul Jungwirth (pjungwir)	New status: Waiting on Author
2026-03-13 07:11:37	warda bibi (warda)	Added warda as reviewer
2026-03-08 10:28:25	Prafulla Ranadive (pprandive)	Added pprandive as reviewer
2026-02-01 00:00:10	CFbot	Moved from CF PG19-4 to CF PG19-Final
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 19098-7f8deb5093c13da2@postgresql.org
2025-12-31 22:58:58	Paul Jungwirth (pjungwir)	Created patch record