From 8579730c14a1aceb98913ebd43b2d12078c064ea Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Mon, 19 Dec 2016 21:45:32 +0000 Subject: Reference sum(tsvector) by explicit namespace, fixes replication with pglogical (and probably bdr) --- gentoobrowse-api/db/schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gentoobrowse-api/db/schema.sql b/gentoobrowse-api/db/schema.sql index 36ebea6..c9c1ea4 100644 --- a/gentoobrowse-api/db/schema.sql +++ b/gentoobrowse-api/db/schema.sql @@ -457,7 +457,7 @@ CREATE FUNCTION newsfts(n news) RETURNS tsvector LANGUAGE plpgsql IMMUTABLE AS $$ BEGIN - RETURN SUM(t) FROM (SELECT TO_TSVECTOR('english', UNNEST(n.body)) t) a; + RETURN gentoobrowse.SUM(t) FROM (SELECT TO_TSVECTOR('english', UNNEST(n.body)) t) a; END $$; ALTER FUNCTION gentoobrowse.newsfts(n news) OWNER TO gentoo; -- cgit v1.2.3