/usr/share/postgresql/10/extension/pgmemcache--2.1--2.1.1.sql is in postgresql-10-pgmemcache 2.3.0-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | \echo Use "ALTER EXTENSION pgmemcache UPDATE TO '2.1.1'" to load this file. \quit
DROP FUNCTION memcache_incr(key text, increment int);
CREATE FUNCTION memcache_incr(key text, increment bigint)
RETURNS bigint
AS 'MODULE_PATHNAME', 'memcache_incr'
LANGUAGE c STRICT;
DROP FUNCTION memcache_incr(key text);
CREATE FUNCTION memcache_incr(key text)
RETURNS bigint
AS 'MODULE_PATHNAME', 'memcache_incr'
LANGUAGE c STRICT;
DROP FUNCTION memcache_decr(key text, decrement int);
CREATE FUNCTION memcache_decr(key text, decrement bigint)
RETURNS bigint
AS 'MODULE_PATHNAME', 'memcache_decr'
LANGUAGE c STRICT;
DROP FUNCTION memcache_decr(key text);
CREATE FUNCTION memcache_decr(key text)
RETURNS bigint
AS 'MODULE_PATHNAME', 'memcache_decr'
LANGUAGE c STRICT;
|