Fix for btree_gist 'infinity' into a GiST index on date

Edit
ID 7517
Title Fix for btree_gist 'infinity' into a GiST index on date
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +89−36, All patches: +89−36
Tags Bugfix
Created 2026-10-26 11:19:19
Last modified 2026-10-26 11:19:19 (57 minutes ago)
Latest email 2026-10-26 11:21:07 (55 minutes ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version stable
Authors Nitin Motiani (nitinmotiani)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date
First at 2026-10-15 14:09:59 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-10-26 11:21:07 by Nitin Motiani <nitinmotiani at google.com>
Latest attachment (v2-0001-btree_gist-Fix-cannot-subtract-infinite-dates-err.patch) at 2026-10-25 11:35:39 from Nitin Motiani <nitinmotiani at google.com>
    Attachment (v2-0001-btree_gist-Fix-cannot-subtract-infinite-dates-err.patch) at 2026-10-25 11:35:39 from Nitin Motiani <nitinmotiani at google.com> (Patch: No)
    Attachment (v1-0001-btree_gist-Fix-cannot-subtract-infinite-dates-err.patch) at 2026-10-16 09:15:26 from Nitin Motiani <nitinmotiani at google.com> (Patch: No)
History
When Who What
2026-10-26 11:19:19 Nitin Motiani (nitinmotiani) Attached mail thread 19761-b72cfc453e487610@postgresql.org
2026-10-26 11:19:19 Nitin Motiani (nitinmotiani) Created patch record
Edit