28 |
SET search_path = public; |
SET search_path = public; |
29 |
|
|
30 |
CREATE OR REPLACE FUNCTION memcache_init() RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_init() RETURNS BOOL |
31 |
AS 'pgmemcache', 'memcache_init' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_init' LANGUAGE 'C'; |
32 |
|
|
33 |
|
|
34 |
-- $1 = server name - TEXT |
-- $1 = server name - TEXT |
35 |
-- $2 = port number - TEXT |
-- $2 = port number - TEXT |
36 |
CREATE OR REPLACE FUNCTION memcache_server_add(TEXT, TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_server_add(TEXT, TEXT) RETURNS BOOL |
37 |
AS 'pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT; |
AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT; |
38 |
|
|
39 |
-- $1 = key to look up server with - TEXT |
-- $1 = key to look up server with - TEXT |
40 |
CREATE OR REPLACE FUNCTION memcache_server_find(TEXT) RETURNS TEXT |
CREATE OR REPLACE FUNCTION memcache_server_find(TEXT) RETURNS TEXT |
41 |
AS 'pgmemcache', 'memcache_server_find' LANGUAGE 'C' STRICT; |
AS '$libdir/pgmemcache', 'memcache_server_find' LANGUAGE 'C' STRICT; |
42 |
|
|
43 |
-- $1 = hash value to look up server with - INT4 |
-- $1 = hash value to look up server with - INT4 |
44 |
CREATE OR REPLACE FUNCTION memcache_server_find(INT4) RETURNS TEXT |
CREATE OR REPLACE FUNCTION memcache_server_find(INT4) RETURNS TEXT |
45 |
AS 'pgmemcache', 'memcache_server_find_hash' LANGUAGE 'C' STRICT; |
AS '$libdir/pgmemcache', 'memcache_server_find_hash' LANGUAGE 'C' STRICT; |
46 |
|
|
47 |
|
|
48 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
50 |
-- $3 = expire - INTERVAL (opt) |
-- $3 = expire - INTERVAL (opt) |
51 |
-- $4 = flags - INT4 (opt) |
-- $4 = flags - INT4 (opt) |
52 |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL |
53 |
AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; |
54 |
|
|
55 |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, INTERVAL) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, INTERVAL) RETURNS BOOL |
56 |
AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; |
57 |
|
|
58 |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT) RETURNS BOOL |
59 |
AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; |
60 |
|
|
61 |
CREATE OR REPLACE FUNCTION memcache_add(TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_add(TEXT) RETURNS BOOL |
62 |
AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; |
63 |
|
|
64 |
|
|
65 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
67 |
-- $3 = expire - INTERVAL (opt) |
-- $3 = expire - INTERVAL (opt) |
68 |
-- $4 = flags - INT4 (opt) |
-- $4 = flags - INT4 (opt) |
69 |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL |
70 |
AS 'pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; |
71 |
|
|
72 |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL |
73 |
AS 'pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; |
74 |
|
|
75 |
|
|
76 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
77 |
CREATE OR REPLACE FUNCTION memcache_get(TEXT) RETURNS TEXT |
CREATE OR REPLACE FUNCTION memcache_get(TEXT) RETURNS TEXT |
78 |
AS 'pgmemcache', 'memcache_get' LANGUAGE 'C' STRICT; |
AS '$libdir/pgmemcache', 'memcache_get' LANGUAGE 'C' STRICT; |
79 |
|
|
80 |
|
|
81 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
82 |
-- $2 = decrement - INT4, default 1 (opt) |
-- $2 = decrement - INT4, default 1 (opt) |
83 |
CREATE OR REPLACE FUNCTION memcache_decr(TEXT, INT4) RETURNS INT4 |
CREATE OR REPLACE FUNCTION memcache_decr(TEXT, INT4) RETURNS INT4 |
84 |
AS 'pgmemcache', 'memcache_decr' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_decr' LANGUAGE 'C'; |
85 |
|
|
86 |
CREATE OR REPLACE FUNCTION memcache_decr(TEXT) RETURNS INT4 |
CREATE OR REPLACE FUNCTION memcache_decr(TEXT) RETURNS INT4 |
87 |
AS 'pgmemcache', 'memcache_decr' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_decr' LANGUAGE 'C'; |
88 |
|
|
89 |
|
|
90 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
91 |
-- $2 = increment - INT4, default 1 (opt) |
-- $2 = increment - INT4, default 1 (opt) |
92 |
CREATE OR REPLACE FUNCTION memcache_incr(TEXT, INT4) RETURNS INT4 |
CREATE OR REPLACE FUNCTION memcache_incr(TEXT, INT4) RETURNS INT4 |
93 |
AS 'pgmemcache', 'memcache_incr' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_incr' LANGUAGE 'C'; |
94 |
|
|
95 |
CREATE OR REPLACE FUNCTION memcache_incr(TEXT) RETURNS INT4 |
CREATE OR REPLACE FUNCTION memcache_incr(TEXT) RETURNS INT4 |
96 |
AS 'pgmemcache', 'memcache_incr' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_incr' LANGUAGE 'C'; |
97 |
|
|
98 |
|
|
99 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
100 |
-- $2 = hold timer - INTERVAL (opt) |
-- $2 = hold timer - INTERVAL (opt) |
101 |
CREATE OR REPLACE FUNCTION memcache_delete(TEXT, INTERVAL) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_delete(TEXT, INTERVAL) RETURNS BOOL |
102 |
AS 'pgmemcache', 'memcache_delete' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_delete' LANGUAGE 'C'; |
103 |
|
|
104 |
CREATE OR REPLACE FUNCTION memcache_delete(TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_delete(TEXT) RETURNS BOOL |
105 |
AS 'pgmemcache', 'memcache_delete' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_delete' LANGUAGE 'C'; |
106 |
|
|
107 |
-- Flush all servers in the cluster |
-- Flush all servers in the cluster |
108 |
CREATE OR REPLACE FUNCTION memcache_flush_all() RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_flush_all() RETURNS BOOL |
109 |
AS 'pgmemcache', 'memcache_flush_all0' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_flush_all0' LANGUAGE 'C'; |
110 |
|
|
111 |
-- $1 = key to server to be flushed |
-- $1 = key to server to be flushed |
112 |
CREATE OR REPLACE FUNCTION memcache_flush(TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_flush(TEXT) RETURNS BOOL |
113 |
AS 'pgmemcache', 'memcache_flush' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_flush' LANGUAGE 'C'; |
114 |
|
|
115 |
-- Cleans up the backend |
-- Cleans up the backend |
116 |
CREATE OR REPLACE FUNCTION memcache_free() RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_free() RETURNS BOOL |
117 |
AS 'pgmemcache', 'memcache_free' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_free' LANGUAGE 'C'; |
118 |
|
|
119 |
CREATE OR REPLACE FUNCTION memcache_hash(TEXT) RETURNS INT4 |
CREATE OR REPLACE FUNCTION memcache_hash(TEXT) RETURNS INT4 |
120 |
AS 'pgmemcache', 'memcache_hash' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_hash' LANGUAGE 'C'; |
121 |
|
|
122 |
|
|
123 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
125 |
-- $3 = expire - INTERVAL (opt) |
-- $3 = expire - INTERVAL (opt) |
126 |
-- $4 = flags - INT4 (opt) |
-- $4 = flags - INT4 (opt) |
127 |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL |
128 |
AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
129 |
|
|
130 |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, INTERVAL) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, INTERVAL) RETURNS BOOL |
131 |
AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
132 |
|
|
133 |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT) RETURNS BOOL |
134 |
AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
135 |
|
|
136 |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT) RETURNS BOOL |
137 |
AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; |
138 |
|
|
139 |
|
|
140 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
142 |
-- $3 = expire - INTERVAL (opt) |
-- $3 = expire - INTERVAL (opt) |
143 |
-- $4 = flags - INT4 (opt) |
-- $4 = flags - INT4 (opt) |
144 |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL |
145 |
AS 'pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; |
146 |
|
|
147 |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL |
148 |
AS 'pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; |
149 |
|
|
150 |
|
|
151 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
153 |
-- $3 = expire - INTERVAL (opt) |
-- $3 = expire - INTERVAL (opt) |
154 |
-- $4 = flags - INT4 (opt) |
-- $4 = flags - INT4 (opt) |
155 |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL |
156 |
AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; |
157 |
|
|
158 |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, INTERVAL) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, INTERVAL) RETURNS BOOL |
159 |
AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; |
160 |
|
|
161 |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT) RETURNS BOOL |
162 |
AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; |
163 |
|
|
164 |
CREATE OR REPLACE FUNCTION memcache_set(TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_set(TEXT) RETURNS BOOL |
165 |
AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; |
166 |
|
|
167 |
|
|
168 |
-- $1 = key - TEXT |
-- $1 = key - TEXT |
170 |
-- $3 = expire - INTERVAL (opt) |
-- $3 = expire - INTERVAL (opt) |
171 |
-- $4 = flags - INT4 (opt) |
-- $4 = flags - INT4 (opt) |
172 |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL |
173 |
AS 'pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; |
174 |
|
|
175 |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL |
176 |
AS 'pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; |
177 |
|
|
178 |
|
|
179 |
CREATE OR REPLACE FUNCTION memcache_stats() RETURNS TEXT |
CREATE OR REPLACE FUNCTION memcache_stats() RETURNS TEXT |
180 |
AS 'pgmemcache', 'memcache_stats' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_stats' LANGUAGE 'C'; |
181 |
|
|
182 |
-- $1 = stat name - TEXT |
-- $1 = stat name - TEXT |
183 |
CREATE OR REPLACE FUNCTION memcache_stats(TEXT) RETURNS TEXT |
CREATE OR REPLACE FUNCTION memcache_stats(TEXT) RETURNS TEXT |
184 |
AS 'pgmemcache', 'memcache_stat' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_stat' LANGUAGE 'C'; |
185 |
|
|
186 |
|
|
187 |
-- DEPRECIATED!!! Use memcache_flush(TEXT) instead!!! |
-- DEPRECIATED!!! Use memcache_flush(TEXT) instead!!! |
188 |
-- $1 = key to server to be flushed |
-- $1 = key to server to be flushed |
189 |
CREATE OR REPLACE FUNCTION memcache_flush_all(TEXT) RETURNS BOOL |
CREATE OR REPLACE FUNCTION memcache_flush_all(TEXT) RETURNS BOOL |
190 |
AS 'pgmemcache', 'memcache_flush_all' LANGUAGE 'C'; |
AS '$libdir/pgmemcache', 'memcache_flush_all' LANGUAGE 'C'; |