File: amcheck--1.0.sql

package info (click to toggle)
postgresql-18 18.3-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 157,012 kB
  • sloc: ansic: 995,386; sql: 128,177; perl: 59,363; xml: 30,905; yacc: 21,024; lex: 9,000; makefile: 6,894; sh: 5,372; cpp: 995; python: 892; asm: 40; sed: 3
file content (24 lines) | stat: -rw-r--r-- 704 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
/* contrib/amcheck/amcheck--1.0.sql */

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION amcheck" to load this file. \quit

--
-- bt_index_check()
--
CREATE FUNCTION bt_index_check(index regclass)
RETURNS VOID
AS 'MODULE_PATHNAME', 'bt_index_check'
LANGUAGE C STRICT PARALLEL RESTRICTED;

--
-- bt_index_parent_check()
--
CREATE FUNCTION bt_index_parent_check(index regclass)
RETURNS VOID
AS 'MODULE_PATHNAME', 'bt_index_parent_check'
LANGUAGE C STRICT PARALLEL RESTRICTED;

-- Don't want these to be available to public
REVOKE ALL ON FUNCTION bt_index_check(regclass) FROM PUBLIC;
REVOKE ALL ON FUNCTION bt_index_parent_check(regclass) FROM PUBLIC;