From 11b9453ebd4c7b78512694f388fe055b0029e7f9 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Tue, 15 Mar 2011 15:51:21 +0000
Subject: [PATCH] make sure search path is set up properly for FTS in 9.0

git-svn-id: svn://svn.open-ils.org/ILS/trunk@19749 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 .../src/sql/Pg/000.english.pg90.fts-config.sql     |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

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
--- 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);
-- 
1.7.2.5