codekingpro/portable-devtools

1/* contrib/pg_visibility/pg_visibility--1.1.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION pg_visibility" to load this file. \quit5 6-- Show visibility map information.7CREATE FUNCTION pg_visibility_map(regclass, blkno bigint,8								  all_visible OUT boolean,9								  all_frozen OUT boolean)10RETURNS record11AS 'MODULE_PATHNAME', 'pg_visibility_map'12LANGUAGE C STRICT;13 14-- Show visibility map and page-level visibility information.15CREATE FUNCTION pg_visibility(regclass, blkno bigint,16							  all_visible OUT boolean,17							  all_frozen OUT boolean,18							  pd_all_visible OUT boolean)19RETURNS record20AS 'MODULE_PATHNAME', 'pg_visibility'21LANGUAGE C STRICT;22 23-- Show visibility map information for each block in a relation.24CREATE FUNCTION pg_visibility_map(regclass, blkno OUT bigint,25								  all_visible OUT boolean,26								  all_frozen OUT boolean)27RETURNS SETOF record28AS 'MODULE_PATHNAME', 'pg_visibility_map_rel'29LANGUAGE C STRICT;30 31-- Show visibility map and page-level visibility information for each block.32CREATE FUNCTION pg_visibility(regclass, blkno OUT bigint,33							  all_visible OUT boolean,34							  all_frozen OUT boolean,35							  pd_all_visible OUT boolean)36RETURNS SETOF record37AS 'MODULE_PATHNAME', 'pg_visibility_rel'38LANGUAGE C STRICT;39 40-- Show summary of visibility map bits for a relation.41CREATE FUNCTION pg_visibility_map_summary(regclass,42    OUT all_visible bigint, OUT all_frozen bigint)43RETURNS record44AS 'MODULE_PATHNAME', 'pg_visibility_map_summary'45LANGUAGE C STRICT;46 47-- Show tupleids of non-frozen tuples if any in all_frozen pages48-- for a relation.49CREATE FUNCTION pg_check_frozen(regclass, t_ctid OUT tid)50RETURNS SETOF tid51AS 'MODULE_PATHNAME', 'pg_check_frozen'52LANGUAGE C STRICT;53 54-- Show tupleids of dead tuples if any in all_visible pages for a relation.55CREATE FUNCTION pg_check_visible(regclass, t_ctid OUT tid)56RETURNS SETOF tid57AS 'MODULE_PATHNAME', 'pg_check_visible'58LANGUAGE C STRICT;59 60-- Truncate the visibility map fork.61CREATE FUNCTION pg_truncate_visibility_map(regclass)62RETURNS void63AS 'MODULE_PATHNAME', 'pg_truncate_visibility_map'64LANGUAGE C STRICT65PARALLEL UNSAFE;  -- let's not make this any more dangerous66 67-- Don't want these to be available to public.68REVOKE ALL ON FUNCTION pg_visibility_map(regclass, bigint) FROM PUBLIC;69REVOKE ALL ON FUNCTION pg_visibility(regclass, bigint) FROM PUBLIC;70REVOKE ALL ON FUNCTION pg_visibility_map(regclass) FROM PUBLIC;71REVOKE ALL ON FUNCTION pg_visibility(regclass) FROM PUBLIC;72REVOKE ALL ON FUNCTION pg_visibility_map_summary(regclass) FROM PUBLIC;73REVOKE ALL ON FUNCTION pg_check_frozen(regclass) FROM PUBLIC;74REVOKE ALL ON FUNCTION pg_check_visible(regclass) FROM PUBLIC;75REVOKE ALL ON FUNCTION pg_truncate_visibility_map(regclass) FROM PUBLIC;76