1/* contrib/pageinspect/pageinspect--1.8--1.9.sql */ 2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION 4\echo Use "ALTER EXTENSION pageinspect UPDATE TO '1.9'" to load this file. \quit 5 6-- 7-- gist_page_opaque_info() 8-- 9CREATE FUNCTION gist_page_opaque_info(IN page bytea, 10 OUT lsn pg_lsn, 11 OUT nsn pg_lsn, 12 OUT rightlink bigint, 13 OUT flags text[]) 14AS 'MODULE_PATHNAME', 'gist_page_opaque_info' 15LANGUAGE C STRICT PARALLEL SAFE; 16 17 18-- 19-- gist_page_items_bytea() 20-- 21CREATE FUNCTION gist_page_items_bytea(IN page bytea, 22 OUT itemoffset smallint, 23 OUT ctid tid, 24 OUT itemlen smallint, 25 OUT dead boolean, 26 OUT key_data bytea) 27RETURNS SETOF record 28AS 'MODULE_PATHNAME', 'gist_page_items_bytea' 29LANGUAGE C STRICT PARALLEL SAFE; 30 31-- 32-- gist_page_items() 33-- 34CREATE FUNCTION gist_page_items(IN page bytea, 35 IN index_oid regclass, 36 OUT itemoffset smallint, 37 OUT ctid tid, 38 OUT itemlen smallint, 39 OUT dead boolean, 40 OUT keys text) 41RETURNS SETOF record 42AS 'MODULE_PATHNAME', 'gist_page_items' 43LANGUAGE C STRICT PARALLEL SAFE; 44 45-- 46-- get_raw_page() 47-- 48DROP FUNCTION get_raw_page(text, int4); 49CREATE FUNCTION get_raw_page(text, int8) 50RETURNS bytea 51AS 'MODULE_PATHNAME', 'get_raw_page_1_9' 52LANGUAGE C STRICT PARALLEL SAFE; 53 54DROP FUNCTION get_raw_page(text, text, int4); 55CREATE FUNCTION get_raw_page(text, text, int8) 56RETURNS bytea 57AS 'MODULE_PATHNAME', 'get_raw_page_fork_1_9' 58LANGUAGE C STRICT PARALLEL SAFE; 59 60-- 61-- page_checksum() 62-- 63DROP FUNCTION page_checksum(IN page bytea, IN blkno int4); 64CREATE FUNCTION page_checksum(IN page bytea, IN blkno int8) 65RETURNS smallint 66AS 'MODULE_PATHNAME', 'page_checksum_1_9' 67LANGUAGE C STRICT PARALLEL SAFE; 68 69-- 70-- bt_metap() 71-- 72DROP FUNCTION bt_metap(text); 73CREATE FUNCTION bt_metap(IN relname text, 74 OUT magic int4, 75 OUT version int4, 76 OUT root int8, 77 OUT level int8, 78 OUT fastroot int8, 79 OUT fastlevel int8, 80 OUT last_cleanup_num_delpages int8, 81 OUT last_cleanup_num_tuples float8, 82 OUT allequalimage boolean) 83AS 'MODULE_PATHNAME', 'bt_metap' 84LANGUAGE C STRICT PARALLEL SAFE; 85 86-- 87-- bt_page_stats() 88-- 89DROP FUNCTION bt_page_stats(text, int4); 90CREATE FUNCTION bt_page_stats(IN relname text, IN blkno int8, 91 OUT blkno int8, 92 OUT type "char", 93 OUT live_items int4, 94 OUT dead_items int4, 95 OUT avg_item_size int4, 96 OUT page_size int4, 97 OUT free_size int4, 98 OUT btpo_prev int8, 99 OUT btpo_next int8, 100 OUT btpo_level int8, 101 OUT btpo_flags int4) 102AS 'MODULE_PATHNAME', 'bt_page_stats_1_9' 103LANGUAGE C STRICT PARALLEL SAFE; 104 105-- 106-- bt_page_items() 107-- 108DROP FUNCTION bt_page_items(text, int4); 109CREATE FUNCTION bt_page_items(IN relname text, IN blkno int8, 110 OUT itemoffset smallint, 111 OUT ctid tid, 112 OUT itemlen smallint, 113 OUT nulls bool, 114 OUT vars bool, 115 OUT data text, 116 OUT dead boolean, 117 OUT htid tid, 118 OUT tids tid[]) 119RETURNS SETOF record 120AS 'MODULE_PATHNAME', 'bt_page_items_1_9' 121LANGUAGE C STRICT PARALLEL SAFE; 122 123-- 124-- brin_page_items() 125-- 126DROP FUNCTION brin_page_items(IN page bytea, IN index_oid regclass); 127CREATE FUNCTION brin_page_items(IN page bytea, IN index_oid regclass, 128 OUT itemoffset int, 129 OUT blknum int8, 130 OUT attnum int, 131 OUT allnulls bool, 132 OUT hasnulls bool, 133 OUT placeholder bool, 134 OUT value text) 135RETURNS SETOF record 136AS 'MODULE_PATHNAME', 'brin_page_items' 137LANGUAGE C STRICT PARALLEL SAFE; 138