1 /* contrib/pageinspect/pageinspect--1.5--1.6.sql */
3 -- complain if script is sourced in psql, rather than via ALTER EXTENSION
4 \echo Use "ALTER EXTENSION pageinspect UPDATE TO '1.6'" to load this file. \quit
13 CREATE FUNCTION hash_page_type(IN page bytea)
15 AS 'MODULE_PATHNAME', 'hash_page_type'
16 LANGUAGE C STRICT PARALLEL SAFE;
21 CREATE FUNCTION hash_page_stats(IN page bytea,
26 OUT hasho_prevblkno int8,
27 OUT hasho_nextblkno int8,
28 OUT hasho_bucket int8,
30 OUT hasho_page_id int4)
31 AS 'MODULE_PATHNAME', 'hash_page_stats'
32 LANGUAGE C STRICT PARALLEL SAFE;
37 CREATE FUNCTION hash_page_items(IN page bytea,
42 AS 'MODULE_PATHNAME', 'hash_page_items'
43 LANGUAGE C STRICT PARALLEL SAFE;
48 CREATE FUNCTION hash_bitmap_info(IN index_oid regclass, IN blkno int8,
53 AS 'MODULE_PATHNAME', 'hash_bitmap_info'
54 LANGUAGE C STRICT PARALLEL SAFE;
57 -- hash_metapage_info()
59 CREATE FUNCTION hash_metapage_info(IN page bytea,
62 OUT ntuples double precision,
76 AS 'MODULE_PATHNAME', 'hash_metapage_info'
77 LANGUAGE C STRICT PARALLEL SAFE;
82 CREATE FUNCTION page_checksum(IN page bytea, IN blkno int4)
84 AS 'MODULE_PATHNAME', 'page_checksum'
85 LANGUAGE C STRICT PARALLEL SAFE;
88 -- bt_page_items_bytea()
90 CREATE FUNCTION bt_page_items(IN page bytea,
91 OUT itemoffset smallint,
98 AS 'MODULE_PATHNAME', 'bt_page_items_bytea'
99 LANGUAGE C STRICT PARALLEL SAFE;