diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2016-12-19 21:45:32 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2016-12-27 17:16:14 +0000 |
| commit | 8579730c14a1aceb98913ebd43b2d12078c064ea (patch) | |
| tree | 314fb964b3c221afa20fbabd2f39b26001e00ae0 | |
| parent | Fix owner of sum(tsvector) (diff) | |
| download | gentoobrowse-api-8579730c14a1aceb98913ebd43b2d12078c064ea.tar.bz2 gentoobrowse-api-8579730c14a1aceb98913ebd43b2d12078c064ea.tar.xz gentoobrowse-api-8579730c14a1aceb98913ebd43b2d12078c064ea.zip | |
Reference sum(tsvector) by explicit namespace, fixes replication with pglogical (and probably bdr)
| -rw-r--r-- | gentoobrowse-api/db/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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; |