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