--- trunk/pgmemcache.sql 2006/07/20 11:29:50 6 +++ trunk/pgmemcache.sql 2006/07/20 11:33:56 7 @@ -28,21 +28,21 @@ SET search_path = public; CREATE OR REPLACE FUNCTION memcache_init() RETURNS BOOL -AS 'pgmemcache', 'memcache_init' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_init' LANGUAGE 'C'; -- $1 = server name - TEXT -- $2 = port number - TEXT CREATE OR REPLACE FUNCTION memcache_server_add(TEXT, TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT; +AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT; -- $1 = key to look up server with - TEXT CREATE OR REPLACE FUNCTION memcache_server_find(TEXT) RETURNS TEXT -AS 'pgmemcache', 'memcache_server_find' LANGUAGE 'C' STRICT; +AS '$libdir/pgmemcache', 'memcache_server_find' LANGUAGE 'C' STRICT; -- $1 = hash value to look up server with - INT4 CREATE OR REPLACE FUNCTION memcache_server_find(INT4) RETURNS TEXT -AS 'pgmemcache', 'memcache_server_find_hash' LANGUAGE 'C' STRICT; +AS '$libdir/pgmemcache', 'memcache_server_find_hash' LANGUAGE 'C' STRICT; -- $1 = key - TEXT @@ -50,16 +50,16 @@ -- $3 = expire - INTERVAL (opt) -- $4 = flags - INT4 (opt) CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL -AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, INTERVAL) RETURNS BOOL -AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_add(TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_add' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_add' LANGUAGE 'C'; -- $1 = key - TEXT @@ -67,57 +67,57 @@ -- $3 = expire - INTERVAL (opt) -- $4 = flags - INT4 (opt) CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL -AS 'pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_add(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL -AS 'pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_add_absexpire' LANGUAGE 'C'; -- $1 = key - TEXT CREATE OR REPLACE FUNCTION memcache_get(TEXT) RETURNS TEXT -AS 'pgmemcache', 'memcache_get' LANGUAGE 'C' STRICT; +AS '$libdir/pgmemcache', 'memcache_get' LANGUAGE 'C' STRICT; -- $1 = key - TEXT -- $2 = decrement - INT4, default 1 (opt) CREATE OR REPLACE FUNCTION memcache_decr(TEXT, INT4) RETURNS INT4 -AS 'pgmemcache', 'memcache_decr' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_decr' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_decr(TEXT) RETURNS INT4 -AS 'pgmemcache', 'memcache_decr' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_decr' LANGUAGE 'C'; -- $1 = key - TEXT -- $2 = increment - INT4, default 1 (opt) CREATE OR REPLACE FUNCTION memcache_incr(TEXT, INT4) RETURNS INT4 -AS 'pgmemcache', 'memcache_incr' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_incr' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_incr(TEXT) RETURNS INT4 -AS 'pgmemcache', 'memcache_incr' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_incr' LANGUAGE 'C'; -- $1 = key - TEXT -- $2 = hold timer - INTERVAL (opt) CREATE OR REPLACE FUNCTION memcache_delete(TEXT, INTERVAL) RETURNS BOOL -AS 'pgmemcache', 'memcache_delete' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_delete' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_delete(TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_delete' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_delete' LANGUAGE 'C'; -- Flush all servers in the cluster CREATE OR REPLACE FUNCTION memcache_flush_all() RETURNS BOOL -AS 'pgmemcache', 'memcache_flush_all0' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_flush_all0' LANGUAGE 'C'; -- $1 = key to server to be flushed CREATE OR REPLACE FUNCTION memcache_flush(TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_flush' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_flush' LANGUAGE 'C'; -- Cleans up the backend CREATE OR REPLACE FUNCTION memcache_free() RETURNS BOOL -AS 'pgmemcache', 'memcache_free' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_free' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_hash(TEXT) RETURNS INT4 -AS 'pgmemcache', 'memcache_hash' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_hash' LANGUAGE 'C'; -- $1 = key - TEXT @@ -125,16 +125,16 @@ -- $3 = expire - INTERVAL (opt) -- $4 = flags - INT4 (opt) CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL -AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, INTERVAL) RETURNS BOOL -AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_replace(TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_replace' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_replace' LANGUAGE 'C'; -- $1 = key - TEXT @@ -142,10 +142,10 @@ -- $3 = expire - INTERVAL (opt) -- $4 = flags - INT4 (opt) CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL -AS 'pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_replace(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL -AS 'pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_replace_absexpire' LANGUAGE 'C'; -- $1 = key - TEXT @@ -153,16 +153,16 @@ -- $3 = expire - INTERVAL (opt) -- $4 = flags - INT4 (opt) CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, INTERVAL, INT4) RETURNS BOOL -AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, INTERVAL) RETURNS BOOL -AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_set(TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_set' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_set' LANGUAGE 'C'; -- $1 = key - TEXT @@ -170,21 +170,21 @@ -- $3 = expire - INTERVAL (opt) -- $4 = flags - INT4 (opt) CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, TIMESTAMP WITH TIME ZONE, INT4) RETURNS BOOL -AS 'pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_set(TEXT, TEXT, TIMESTAMP WITH TIME ZONE) RETURNS BOOL -AS 'pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_set_absexpire' LANGUAGE 'C'; CREATE OR REPLACE FUNCTION memcache_stats() RETURNS TEXT -AS 'pgmemcache', 'memcache_stats' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_stats' LANGUAGE 'C'; -- $1 = stat name - TEXT CREATE OR REPLACE FUNCTION memcache_stats(TEXT) RETURNS TEXT -AS 'pgmemcache', 'memcache_stat' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_stat' LANGUAGE 'C'; -- DEPRECIATED!!! Use memcache_flush(TEXT) instead!!! -- $1 = key to server to be flushed CREATE OR REPLACE FUNCTION memcache_flush_all(TEXT) RETURNS BOOL -AS 'pgmemcache', 'memcache_flush_all' LANGUAGE 'C'; +AS '$libdir/pgmemcache', 'memcache_flush_all' LANGUAGE 'C';