Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

rootpgsqlshareextensionpg_visibility--1.0--1.1.sql

pg_visibility--1.0--1.1.sql25 linesDownload Raw Back to extension

1/* contrib/pg_visibility/pg_visibility--1.0--1.1.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pg_visibility UPDATE TO '1.1'" to load this file. \quit5 6CREATE FUNCTION pg_check_frozen(regclass, t_ctid OUT tid)7RETURNS SETOF tid8AS 'MODULE_PATHNAME', 'pg_check_frozen'9LANGUAGE C STRICT;10 11CREATE FUNCTION pg_check_visible(regclass, t_ctid OUT tid)12RETURNS SETOF tid13AS 'MODULE_PATHNAME', 'pg_check_visible'14LANGUAGE C STRICT;15 16CREATE FUNCTION pg_truncate_visibility_map(regclass)17RETURNS void18AS 'MODULE_PATHNAME', 'pg_truncate_visibility_map'19LANGUAGE C STRICT20PARALLEL UNSAFE;  -- let's not make this any more dangerous21 22REVOKE ALL ON FUNCTION pg_check_frozen(regclass) FROM PUBLIC;23REVOKE ALL ON FUNCTION pg_check_visible(regclass) FROM PUBLIC;24REVOKE ALL ON FUNCTION pg_truncate_visibility_map(regclass) FROM PUBLIC;25