codekingpro/portable-devtools

1/* contrib/pg_visibility/pg_visibility--1.1--1.2.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pg_visibility UPDATE TO '1.2'" to load this file. \quit5 6-- Allow use of monitoring functions by pg_monitor members7GRANT EXECUTE ON FUNCTION pg_visibility_map(regclass, bigint) TO pg_stat_scan_tables;8GRANT EXECUTE ON FUNCTION pg_visibility(regclass, bigint) TO pg_stat_scan_tables;9GRANT EXECUTE ON FUNCTION pg_visibility_map(regclass) TO pg_stat_scan_tables;10GRANT EXECUTE ON FUNCTION pg_visibility(regclass) TO pg_stat_scan_tables;11GRANT EXECUTE ON FUNCTION pg_visibility_map_summary(regclass) TO pg_stat_scan_tables;12GRANT EXECUTE ON FUNCTION pg_check_frozen(regclass) TO pg_stat_scan_tables;13GRANT EXECUTE ON FUNCTION pg_check_visible(regclass) TO pg_stat_scan_tables;14