contrib/amcheck/amcheck--1.2--1.3.sql

   1 /* contrib/amcheck/amcheck--1.2--1.3.sql */
   2
   3 -- complain if script is sourced in psql, rather than via CREATE EXTENSION
   4 \echo Use "ALTER EXTENSION amcheck UPDATE TO '1.3'" to load this file. \quit
   5
   6 --
   7 -- verify_heapam()
   8 --
   9 CREATE 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)
  19 RETURNS SETOF record
  20 AS 'MODULE_PATHNAME', 'verify_heapam'
  21 LANGUAGE C;
  22
  23 -- Don't want this to be available to public
  24 REVOKE ALL ON FUNCTION verify_heapam(regclass,
  25                                                                          boolean,
  26                                                                          boolean,
  27                                                                          text,
  28                                                                          bigint,
  29                                                                          bigint)
  30 FROM PUBLIC;