diff options
| author | Yorhel <git@yorhel.nl> | 2019-06-28 07:37:00 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-06-28 07:37:02 +0200 |
| commit | 670c294ff6efeead61e215679224604848229c82 (patch) | |
| tree | 10598f535cef354970efac499a718a5699c0a80a /util/sql/func.sql | |
| parent | 0096b8af096ce08ef7ebb6bb5e8f91a4a6042d8a (diff) | |
SQL: Use schema-qualified strip_bb_tags() in bb_tsvector()
Fixes a minor bug with importing a DB dump; During the import the
"public" schema is not in the search path, so the creation of the search
index would fail.
Diffstat (limited to 'util/sql/func.sql')
| -rw-r--r-- | util/sql/func.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 494a6046..93025dfe 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -21,7 +21,7 @@ $$ LANGUAGE sql IMMUTABLE; -- ensure the query planner realizes that this function is _slow_. CREATE OR REPLACE FUNCTION bb_tsvector(t text) RETURNS tsvector AS $$ BEGIN - RETURN to_tsvector('english', strip_bb_tags(t)); + RETURN to_tsvector('english', public.strip_bb_tags(t)); END; $$ LANGUAGE plpgsql IMMUTABLE COST 500; |