diff options
| -rw-r--r-- | contrib/pageinspect/expected/page.out | 5 | ||||
| -rw-r--r-- | contrib/pageinspect/sql/page.sql | 3 |
2 files changed, 5 insertions, 3 deletions
diff --git a/contrib/pageinspect/expected/page.out b/contrib/pageinspect/expected/page.out index 04fd9dee4bd..3fd3869c82a 100644 --- a/contrib/pageinspect/expected/page.out +++ b/contrib/pageinspect/expected/page.out @@ -240,11 +240,12 @@ SELECT page_checksum(decode(repeat('00', :block_size), 'hex'), 1); (1 row) -- tests for sequences -create temporary sequence test_sequence; +create sequence test_sequence start 72057594037927937; select tuple_data_split('test_sequence'::regclass, t_data, t_infomask, t_infomask2, t_bits) from heap_page_items(get_raw_page('test_sequence', 0)); tuple_data_split ------------------------------------------------------- - {"\\x0100000000000000","\\x0000000000000000","\\x00"} + {"\\x0100000000000001","\\x0000000000000000","\\x00"} (1 row) +drop sequence test_sequence; diff --git a/contrib/pageinspect/sql/page.sql b/contrib/pageinspect/sql/page.sql index 59784fc7cce..346e4ee142c 100644 --- a/contrib/pageinspect/sql/page.sql +++ b/contrib/pageinspect/sql/page.sql @@ -100,6 +100,7 @@ SELECT page_header(decode(repeat('00', :block_size), 'hex')); SELECT page_checksum(decode(repeat('00', :block_size), 'hex'), 1); -- tests for sequences -create temporary sequence test_sequence; +create sequence test_sequence start 72057594037927937; select tuple_data_split('test_sequence'::regclass, t_data, t_infomask, t_infomask2, t_bits) from heap_page_items(get_raw_page('test_sequence', 0)); +drop sequence test_sequence; |