1/* contrib/pageinspect/pageinspect--1.7--1.8.sql */
2
3-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4\echo Use "ALTER EXTENSION pageinspect UPDATE TO '1.8'" to load this file. \quit
5
6--
7-- heap_tuple_infomask_flags()
8--
9CREATE FUNCTION heap_tuple_infomask_flags(
10       t_infomask integer,
11       t_infomask2 integer,
12       raw_flags OUT text[],
13       combined_flags OUT text[])
14RETURNS record
15AS 'MODULE_PATHNAME', 'heap_tuple_infomask_flags'
16LANGUAGE C STRICT PARALLEL SAFE;
17
18--
19-- bt_metap()
20--
21DROP FUNCTION bt_metap(text);
22CREATE FUNCTION bt_metap(IN relname text,
23    OUT magic int4,
24    OUT version int4,
25    OUT root int8,
26    OUT level int8,
27    OUT fastroot int8,
28    OUT fastlevel int8,
29    OUT oldest_xact xid,
30    OUT last_cleanup_num_tuples float8,
31    OUT allequalimage boolean)
32AS 'MODULE_PATHNAME', 'bt_metap'
33LANGUAGE C STRICT PARALLEL SAFE;
34
35--
36-- bt_page_items(text, int4)
37--
38DROP FUNCTION bt_page_items(text, int4);
39CREATE FUNCTION bt_page_items(IN relname text, IN blkno int4,
40    OUT itemoffset smallint,
41    OUT ctid tid,
42    OUT itemlen smallint,
43    OUT nulls bool,
44    OUT vars bool,
45    OUT data text,
46    OUT dead boolean,
47    OUT htid tid,
48    OUT tids tid[])
49RETURNS SETOF record
50AS 'MODULE_PATHNAME', 'bt_page_items'
51LANGUAGE C STRICT PARALLEL SAFE;
52
53--
54-- bt_page_items(bytea)
55--
56DROP FUNCTION bt_page_items(bytea);
57CREATE FUNCTION bt_page_items(IN page bytea,
58    OUT itemoffset smallint,
59    OUT ctid tid,
60    OUT itemlen smallint,
61    OUT nulls bool,
62    OUT vars bool,
63    OUT data text,
64    OUT dead boolean,
65    OUT htid tid,
66    OUT tids tid[])
67RETURNS SETOF record
68AS 'MODULE_PATHNAME', 'bt_page_items_bytea'
69LANGUAGE C STRICT PARALLEL SAFE;
70