postgres

History

Nathan Bossart 0970889e35 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		1 year ago
..
brin.out	pageinspect: Fix crash with gist_page_items()	3 years ago
btree.out	pageinspect: Fix handling of all-zero pages	3 years ago
checksum.out	Add an explicit test to catch changes in checksumming calculations.	6 years ago
checksum_1.out	Add an explicit test to catch changes in checksumming calculations.	6 years ago
gin.out	pageinspect: Fix handling of all-zero pages	3 years ago
gist.out	pageinspect: Fix gist_page_items() with included columns	2 years ago
hash.out	pageinspect: Fix failure with hash_bitmap_info() for partitioned indexes	2 years ago
oldextversions.out	pageinspect: Change block number arguments to bigint	5 years ago
page.out	Fix contrib/pageinspect's test for sequences.	1 year ago