/usr/share/postgresql/9.6/extension/citus--5.0--5.0-1.sql is in postgresql-9.6-citus 6.0.1.PGDG-1.
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 26 27 28 29 30 31 | /* citus--5.0--5.0-1.sql */
CREATE FUNCTION pg_catalog.master_stage_shard_row(logicalrelid oid,
shardid bigint,
shardstorage "char",
shardminvalue text,
shardmaxvalue text)
RETURNS VOID
LANGUAGE C
AS 'MODULE_PATHNAME', $$master_stage_shard_row$$;
COMMENT ON FUNCTION pg_catalog.master_stage_shard_row(oid, bigint, "char", text, text)
IS 'deprecated function to insert a row into pg_dist_shard';
CREATE FUNCTION pg_catalog.master_stage_shard_placement_row(shardid int8,
shardstate int4,
shardlength int8,
nodename text,
nodeport int4)
RETURNS VOID
STRICT
LANGUAGE C
AS 'MODULE_PATHNAME', $$master_stage_shard_placement_row$$;
COMMENT ON FUNCTION pg_catalog.master_stage_shard_placement_row(int8, int4, int8, text, int4)
IS 'deprecated function to insert a row into pg_dist_shard_placement';
ALTER FUNCTION pg_catalog.citus_drop_trigger() SECURITY DEFINER;
GRANT SELECT ON pg_catalog.pg_dist_partition TO public;
GRANT SELECT ON pg_catalog.pg_dist_shard TO public;
GRANT SELECT ON pg_catalog.pg_dist_shard_placement TO public;
|