make sure search path is set up properly for FTS in 9.0

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 000.english.pg90.fts-config.sql

diff --git a/Open-ILS/src/sql/Pg/000.english.pg90.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg90.fts-config.sql
index e4e50e4..7ddce06 100644 (file)
--- a/Open-ILS/src/sql/Pg/000.english.pg90.fts-config.sql
+++ b/Open-ILS/src/sql/Pg/000.english.pg90.fts-config.sql
@@ -18,6 +18,8 @@
 
 BEGIN;
 
+SET search_path = public, pg_catalog;
+
 CREATE OR REPLACE FUNCTION oils_tsearch2 () RETURNS TRIGGER AS $$
 BEGIN
        NEW.index_vector = to_tsvector((TG_ARGV[0])::regconfig, NEW.value);