From a02731cb10535a6d5f66447295e7b8e22807f471 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 17 Mar 2017 09:23:39 -0400 Subject: [PATCH] pageinspect: Add test for page_header function --- contrib/pageinspect/expected/page.out | 6 ++++++ contrib/pageinspect/sql/page.sql | 2 ++ 2 files changed, 8 insertions(+) diff --git a/contrib/pageinspect/expected/page.out b/contrib/pageinspect/expected/page.out index 9eaeda3a27..08599af774 100644 --- a/contrib/pageinspect/expected/page.out +++ b/contrib/pageinspect/expected/page.out @@ -43,6 +43,12 @@ SELECT get_raw_page('test1', 0) = get_raw_page('test1', 'main', 0); t (1 row) +SELECT pagesize, version FROM page_header(get_raw_page('test1', 0)); + pagesize | version +----------+--------- + 8192 | 4 +(1 row) + SELECT tuple_data_split('test1'::regclass, t_data, t_infomask, t_infomask2, t_bits) FROM heap_page_items(get_raw_page('test1', 0)); tuple_data_split diff --git a/contrib/pageinspect/sql/page.sql b/contrib/pageinspect/sql/page.sql index 6b2e6b79a2..53e9f8022d 100644 --- a/contrib/pageinspect/sql/page.sql +++ b/contrib/pageinspect/sql/page.sql @@ -22,6 +22,8 @@ SELECT octet_length(get_raw_page('test1', 'xxx', 0)); SELECT get_raw_page('test1', 0) = get_raw_page('test1', 'main', 0); +SELECT pagesize, version FROM page_header(get_raw_page('test1', 0)); + SELECT tuple_data_split('test1'::regclass, t_data, t_infomask, t_infomask2, t_bits) FROM heap_page_items(get_raw_page('test1', 0)); -- 2.40.0