aboutsummaryrefslogtreecommitdiff
path: root/src/backend/commands/dbcommands.c
diff options
context:
space:
mode:
authorNoah Misch <noah@leadboat.com>2023-10-14 16:33:51 -0700
committerNoah Misch <noah@leadboat.com>2023-10-14 16:33:51 -0700
commit5f27b5f848a433ba54c521ccb889788b8f4d6ba7 (patch)
tree88f846e810c8a398148c1cef63b9de252b51b197 /src/backend/commands/dbcommands.c
parent90ebcc32d9829204bfd15db82ece3aacd84f40d6 (diff)
downloadpostgresql-5f27b5f848a433ba54c521ccb889788b8f4d6ba7.tar.gz
postgresql-5f27b5f848a433ba54c521ccb889788b8f4d6ba7.zip
Dissociate btequalimage() from interval_ops, ending its deduplication.
Under interval_ops, some equal values are distinguishable. One such pair is '24:00:00' and '1 day'. With that being so, btequalimage() breaches the documented contract for the "equalimage" btree support function. This can cause incorrect results from index-only scans. Users should REINDEX any btree indexes having interval-type columns. After updating, pg_amcheck will report an error for almost all such indexes. This fix makes interval_ops simply omit the support function, like numeric_ops does. Back-pack to v13, where btequalimage() first appeared. In back branches, for the benefit of old catalog content, btequalimage() code will return false for type "interval". Going forward, back-branch initdb will include the catalog change. Reviewed by Peter Geoghegan. Discussion: https://postgr.es/m/20231011013317.22.nmisch@google.com
Diffstat (limited to 'src/backend/commands/dbcommands.c')
0 files changed, 0 insertions, 0 deletions