Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

rootpgsqlshareextensionamcheck--1.2--1.3.sql

amcheck--1.2--1.3.sql31 linesDownload Raw Back to extension

1/* contrib/amcheck/amcheck--1.2--1.3.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "ALTER EXTENSION amcheck UPDATE TO '1.3'" to load this file. \quit5 6--7-- verify_heapam()8--9CREATE FUNCTION verify_heapam(relation regclass,10							  on_error_stop boolean default false,11							  check_toast boolean default false,12							  skip text default 'none',13							  startblock bigint default null,14							  endblock bigint default null,15							  blkno OUT bigint,16							  offnum OUT integer,17							  attnum OUT integer,18							  msg OUT text)19RETURNS SETOF record20AS 'MODULE_PATHNAME', 'verify_heapam'21LANGUAGE C;22 23-- Don't want this to be available to public24REVOKE ALL ON FUNCTION verify_heapam(regclass,25									 boolean,26									 boolean,27									 text,28									 bigint,29									 bigint)30FROM PUBLIC;31