From 5c6fc4876e5e5415e9c34a6dd139aae37add4425 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
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