-
Notifications
You must be signed in to change notification settings - Fork 4
/
pgc_fdw--1.0.sql
44 lines (36 loc) · 1.03 KB
/
pgc_fdw--1.0.sql
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
39
40
41
42
43
44
/* contrib/pgc_fdw/pgc_fdw--1.0.sql */
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION pgc_fdw" to load this file. \quit
CREATE FUNCTION pgc_fdw_handler()
RETURNS fdw_handler
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT;
CREATE FUNCTION pgc_fdw_validator(text[], oid)
RETURNS void
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT;
CREATE FOREIGN DATA WRAPPER pgc_fdw
HANDLER pgc_fdw_handler
VALIDATOR pgc_fdw_validator;
CREATE FUNCTION pgc_fdw_cache_info(
OUT sha text,
OUT ts timestamp with time zone,
OUT tupcnt int,
OUT qry text
) RETURNS SETOF record
AS 'MODULE_PATHNAME', 'pgc_fdw_cache_info'
LANGUAGE C;
CREATE FUNCTION pgc_fdw_set(sha text,
ts timestamp with time zone,
tupcnt int,
qry text) RETURNS int
AS 'MODULE_PATHNAME', 'pgc_fdw_set'
LANGUAGE C;
CREATE FUNCTION pgc_fdw_watch(sha text)
RETURNS int
AS 'MODULE_PATHNAME', 'pgc_fdw_watch'
LANGUAGE C;
CREATE FUNCTION pgc_fdw_invalidate(sha text)
RETURNS int
AS 'MODULE_PATHNAME', 'pgc_fdw_invalidate'
LANGUAGE C;