postgres/contrib/pageinspect
Nathan Bossart 70d1c664f4 Fix contrib/pageinspect's test for sequences.
I managed to break this test in two different ways in commit
05036a3155.

First, the output of the new call to tuple_data_split() on the test
sequence is dependent on endianness.  This is fixed by setting a
special start value for the test sequence that produces the same
output regardless of the endianness of the machine.

Second, on versions older than v15, the new test case fails under
"force_parallel_mode = regress" with the following error:

	ERROR:  cannot access temporary tables during a parallel operation

This is because pageinspect's disk-accessing functions are
incorrectly marked PARALLEL SAFE on versions older than v15 (see
commit aeaaf520f4 for details).  This one is fixed by changing the
test sequence to be permanent.  The only reason it was previously
marked temporary was to avoid needing a DROP SEQUENCE command at
the end of the test.  Unlike some other tests in this file, the use
of a permanent sequence here shouldn't result in any test
instability like what was fixed by commit e2933a6e11.

Reviewed-by: Tom Lane
Discussion: https://postgr.es/m/ZuOKOut5hhDlf_bP%40nathan
Backpatch-through: 12
2024-09-13 10:16:40 -05:00
..
expected Fix contrib/pageinspect's test for sequences. 2024-09-13 10:16:40 -05:00
sql Fix contrib/pageinspect's test for sequences. 2024-09-13 10:16:40 -05:00
.gitignore pageinspect: Add tests 2016-11-01 14:02:16 -04:00
Makefile Add bt_multi_page_stats() function to contrib/pageinspect. 2023-01-02 13:02:29 -05:00
brinfuncs.c Update copyright for 2024 2024-01-03 20:49:05 -05: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 Use TupleDescAttr macro consistently 2024-07-02 13:41:47 +12: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
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