codekingpro/portable-devtools

1/* contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pg_walinspect UPDATE TO '1.1'" to load this file. \quit5 6-- Unsupported functions after 1.1.7DROP FUNCTION pg_get_wal_records_info_till_end_of_wal(pg_lsn);8DROP FUNCTION pg_get_wal_stats_till_end_of_wal(pg_lsn, boolean);9 10--11-- pg_get_wal_block_info()12--13CREATE FUNCTION pg_get_wal_block_info(IN start_lsn pg_lsn,14	IN end_lsn pg_lsn,15	IN show_data boolean DEFAULT true,16	OUT start_lsn pg_lsn,17	OUT end_lsn pg_lsn,18	OUT prev_lsn pg_lsn,19	OUT block_id int2,20	OUT reltablespace oid,21	OUT reldatabase oid,22	OUT relfilenode oid,23	OUT relforknumber int2,24	OUT relblocknumber int8,25	OUT xid xid,26	OUT resource_manager text,27	OUT record_type text,28	OUT record_length int4,29	OUT main_data_length int4,30	OUT block_data_length int4,31	OUT block_fpi_length int4,32	OUT block_fpi_info text[],33	OUT description text,34	OUT block_data bytea,35	OUT block_fpi_data bytea36)37RETURNS SETOF record38AS 'MODULE_PATHNAME', 'pg_get_wal_block_info'39LANGUAGE C STRICT PARALLEL SAFE;40 41REVOKE EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) FROM PUBLIC;42GRANT EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) TO pg_read_server_files;43