1
/* contrib/dblink/dblink--1.0.sql */
3
-- dblink_connect now restricts non-superusers to password
4
-- authenticated connections
5
CREATE FUNCTION dblink_connect (text)
7
AS 'MODULE_PATHNAME','dblink_connect'
10
CREATE FUNCTION dblink_connect (text, text)
12
AS 'MODULE_PATHNAME','dblink_connect'
15
-- dblink_connect_u allows non-superusers to use
16
-- non-password authenticated connections, but initially
17
-- privileges are revoked from public
18
CREATE FUNCTION dblink_connect_u (text)
20
AS 'MODULE_PATHNAME','dblink_connect'
21
LANGUAGE C STRICT SECURITY DEFINER;
23
CREATE FUNCTION dblink_connect_u (text, text)
25
AS 'MODULE_PATHNAME','dblink_connect'
26
LANGUAGE C STRICT SECURITY DEFINER;
28
REVOKE ALL ON FUNCTION dblink_connect_u (text) FROM public;
29
REVOKE ALL ON FUNCTION dblink_connect_u (text, text) FROM public;
31
CREATE FUNCTION dblink_disconnect ()
33
AS 'MODULE_PATHNAME','dblink_disconnect'
36
CREATE FUNCTION dblink_disconnect (text)
38
AS 'MODULE_PATHNAME','dblink_disconnect'
41
CREATE FUNCTION dblink_open (text, text)
43
AS 'MODULE_PATHNAME','dblink_open'
46
CREATE FUNCTION dblink_open (text, text, boolean)
48
AS 'MODULE_PATHNAME','dblink_open'
51
CREATE FUNCTION dblink_open (text, text, text)
53
AS 'MODULE_PATHNAME','dblink_open'
56
CREATE FUNCTION dblink_open (text, text, text, boolean)
58
AS 'MODULE_PATHNAME','dblink_open'
61
CREATE FUNCTION dblink_fetch (text, int)
63
AS 'MODULE_PATHNAME','dblink_fetch'
66
CREATE FUNCTION dblink_fetch (text, int, boolean)
68
AS 'MODULE_PATHNAME','dblink_fetch'
71
CREATE FUNCTION dblink_fetch (text, text, int)
73
AS 'MODULE_PATHNAME','dblink_fetch'
76
CREATE FUNCTION dblink_fetch (text, text, int, boolean)
78
AS 'MODULE_PATHNAME','dblink_fetch'
81
CREATE FUNCTION dblink_close (text)
83
AS 'MODULE_PATHNAME','dblink_close'
86
CREATE FUNCTION dblink_close (text, boolean)
88
AS 'MODULE_PATHNAME','dblink_close'
91
CREATE FUNCTION dblink_close (text, text)
93
AS 'MODULE_PATHNAME','dblink_close'
96
CREATE FUNCTION dblink_close (text, text, boolean)
98
AS 'MODULE_PATHNAME','dblink_close'
101
CREATE FUNCTION dblink (text, text)
103
AS 'MODULE_PATHNAME','dblink_record'
106
CREATE FUNCTION dblink (text, text, boolean)
108
AS 'MODULE_PATHNAME','dblink_record'
111
CREATE FUNCTION dblink (text)
113
AS 'MODULE_PATHNAME','dblink_record'
116
CREATE FUNCTION dblink (text, boolean)
118
AS 'MODULE_PATHNAME','dblink_record'
121
CREATE FUNCTION dblink_exec (text, text)
123
AS 'MODULE_PATHNAME','dblink_exec'
126
CREATE FUNCTION dblink_exec (text, text, boolean)
128
AS 'MODULE_PATHNAME','dblink_exec'
131
CREATE FUNCTION dblink_exec (text)
133
AS 'MODULE_PATHNAME','dblink_exec'
136
CREATE FUNCTION dblink_exec (text,boolean)
138
AS 'MODULE_PATHNAME','dblink_exec'
141
CREATE TYPE dblink_pkey_results AS (position int, colname text);
143
CREATE FUNCTION dblink_get_pkey (text)
144
RETURNS setof dblink_pkey_results
145
AS 'MODULE_PATHNAME','dblink_get_pkey'
148
CREATE FUNCTION dblink_build_sql_insert (text, int2vector, int, _text, _text)
150
AS 'MODULE_PATHNAME','dblink_build_sql_insert'
153
CREATE FUNCTION dblink_build_sql_delete (text, int2vector, int, _text)
155
AS 'MODULE_PATHNAME','dblink_build_sql_delete'
158
CREATE FUNCTION dblink_build_sql_update (text, int2vector, int, _text, _text)
160
AS 'MODULE_PATHNAME','dblink_build_sql_update'
163
CREATE FUNCTION dblink_current_query ()
165
AS 'MODULE_PATHNAME','dblink_current_query'
168
CREATE FUNCTION dblink_send_query(text, text)
170
AS 'MODULE_PATHNAME', 'dblink_send_query'
173
CREATE FUNCTION dblink_is_busy(text)
175
AS 'MODULE_PATHNAME', 'dblink_is_busy'
178
CREATE FUNCTION dblink_get_result(text)
180
AS 'MODULE_PATHNAME', 'dblink_get_result'
183
CREATE FUNCTION dblink_get_result(text, bool)
185
AS 'MODULE_PATHNAME', 'dblink_get_result'
188
CREATE FUNCTION dblink_get_connections()
190
AS 'MODULE_PATHNAME', 'dblink_get_connections'
193
CREATE FUNCTION dblink_cancel_query(text)
195
AS 'MODULE_PATHNAME', 'dblink_cancel_query'
198
CREATE FUNCTION dblink_error_message(text)
200
AS 'MODULE_PATHNAME', 'dblink_error_message'
203
CREATE FUNCTION dblink_get_notify(
204
OUT notify_name TEXT,
209
AS 'MODULE_PATHNAME', 'dblink_get_notify'
212
CREATE FUNCTION dblink_get_notify(
214
OUT notify_name TEXT,
219
AS 'MODULE_PATHNAME', 'dblink_get_notify'