1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
CREATE OR REPLACE FUNCTION getstructurescount(text) RETURNS int AS $$
begin
return BINGO_SCHEMANAME._get_structures_count($1::regclass::oid);
end;
$$ LANGUAGE 'plpgsql';
CREATE OR REPLACE FUNCTION getblockcount(text) RETURNS int AS $$
begin
return BINGO_SCHEMANAME._get_block_count($1::regclass::oid);
end;
$$ LANGUAGE 'plpgsql';
CREATE OR REPLACE FUNCTION precachedatabase(text, text) RETURNS text AS $$
begin
return BINGO_SCHEMANAME._precache_database($1::regclass::oid, $2);
end;
$$ LANGUAGE 'plpgsql';
CREATE OR REPLACE FUNCTION _internal_func_011(integer, text, text) RETURNS void AS $$
BEGIN
IF NOT BINGO_SCHEMANAME._internal_func_check($1)
THEN RETURN;
END IF;
INSERT INTO pg_depend (classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype)
VALUES (
'pg_class'::regclass::oid, $2::regclass::oid, 0,
'pg_class'::regclass::oid, $3::regclass::oid, 0, 'i');
end;
$$ LANGUAGE 'plpgsql' SECURITY DEFINER;
CREATE OR REPLACE FUNCTION _internal_func_012(integer, text) RETURNS void AS $$
BEGIN
IF NOT BINGO_SCHEMANAME._internal_func_check($1)
THEN RETURN;
END IF;
DELETE FROM pg_depend WHERE objid=$2::regclass::oid;
end;
$$ LANGUAGE 'plpgsql' SECURITY DEFINER;
|
