postgres/contrib/pageinspect
Tomas Vondra 3668c1d506 Detect version mismatch in brin_page_items
Commit dae761a87e modified brin_page_items() to return the new "empty"
flag for each BRIN range. But the new output parameter was added in the
middle, which may cause crashes when using the new binary with old
function definition.

The ideal solution would be to introduce API versioning similar to what
pg_stat_statements does, but it's too late for that as PG17 was already
released (so we can't introduce a new extension version). We could do
something similar in brin_page_items() by checking the number of output
columns (and ignoring the new flag), but it doesn't seem very nice.

Instead, simply error out and suggest updating the extension to the
latest version. pageinspect is a superuser-only extension, and there's
not much reason to run an older version. Moreover, there's a precedent
for this approach in 691e8b2e18.

Reported by Ľuboslav Špilák, investigation and patch by me. Backpatch to
17, same as dae761a87e.

Reported-by: Ľuboslav Špilák
Reviewed-by: Michael Paquier, Hayato Kuroda, Peter Geoghegan
Backpatch-through: 17
Discussion: https://postgr.es/m/VI1PR02MB63331C3D90E2104FD12399D38A5D2@VI1PR02MB6333.eurprd02.prod.outlook.com
Discussion: https://postgr.es/m/flat/3385a58f-5484-49d0-b790-9a198a0bf236@vondra.me
2024-12-17 17:50:13 +01:00
..
expected Detect version mismatch in brin_page_items 2024-12-17 17:50:13 +01:00
sql Detect version mismatch in brin_page_items 2024-12-17 17:50:13 +01:00
.gitignore pageinspect: Add tests 2016-11-01 14:02:16 -04:00
brinfuncs.c Detect version mismatch in brin_page_items 2024-12-17 17:50:13 +01:00
btreefuncs.c Consolidate ItemPointer to Datum conversion functions 2023-02-13 09:57:15 +01:00
fsmfuncs.c Update copyright for 2024 2024-01-03 20:49:05 -05:00
ginfuncs.c Update copyright for 2024 2024-01-03 20:49:05 -05:00
gistfuncs.c Make the order of the header file includes consistent 2024-03-13 15:07:00 +01:00
hashfuncs.c Update copyright for 2024 2024-01-03 20:49:05 -05:00
heapfuncs.c Reintroduce support for sequences in pgstattuple and pageinspect. 2024-09-12 16:31:29 -05:00
Makefile Add bt_multi_page_stats() function to contrib/pageinspect. 2023-01-02 13:02:29 -05:00
meson.build Update copyright for 2024 2024-01-03 20:49:05 -05:00
pageinspect--1.0--1.1.sql Fix typos in some error messages thrown by extension scripts when fed to psql. 2014-08-25 18:30:37 +02:00
pageinspect--1.1--1.2.sql Fix typos in some error messages thrown by extension scripts when fed to psql. 2014-08-25 18:30:37 +02:00
pageinspect--1.2--1.3.sql pageinspect/BRIN: minor tweaks 2014-12-02 12:20:50 -03:00
pageinspect--1.3--1.4.sql Add forgotten file in commit d6061f83a1 2015-11-25 16:59:07 +03:00
pageinspect--1.4--1.5.sql Update pageinspect extension for parallel query. 2016-06-09 17:18:09 -04:00
pageinspect--1.5--1.6.sql pageinspect: Add bt_page_items function with bytea argument 2017-04-04 23:52:55 -04:00
pageinspect--1.5.sql Update pageinspect extension for parallel query. 2016-06-09 17:18:09 -04:00
pageinspect--1.6--1.7.sql Skip full index scan during cleanup of B-tree indexes when possible 2018-04-04 19:29:00 +03:00
pageinspect--1.7--1.8.sql pageinspect: Fix types used for bt_metap() columns. 2020-03-07 16:44:53 -08:00
pageinspect--1.8--1.9.sql Use full 64-bit XIDs in deleted nbtree pages. 2021-02-24 18:41:34 -08:00
pageinspect--1.9--1.10.sql pageinspect: Improve page_header() for pages of 32kB 2021-07-12 11:05:27 +09:00
pageinspect--1.10--1.11.sql Mark pageinspect's disk-accessing functions as parallel restricted. 2022-11-21 15:37:10 -05:00
pageinspect--1.11--1.12.sql Show empty BRIN ranges in brin_page_items 2023-05-19 02:00:21 +02:00
pageinspect.control Add bt_multi_page_stats() function to contrib/pageinspect. 2023-01-02 13:02:29 -05:00
pageinspect.h Update copyright for 2024 2024-01-03 20:49:05 -05:00
rawpage.c Update copyright for 2024 2024-01-03 20:49:05 -05:00