From a864653402756d141fbda4104479b8b071ef86ed Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Sun, 18 Feb 2007 13:31:08 +0000
Subject: [PATCH] use new fulltext strategies for initial indexing

git-svn-id: svn://svn.open-ils.org/ILS/trunk@6965 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/030.schema.metabib.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
index cc25d10bae..f51109dfed 100644
--- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql
+++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
@@ -21,7 +21,7 @@ CREATE TABLE metabib.title_field_entry (
 );
 CREATE TRIGGER metabib_title_field_entry_fti_trigger
 	BEFORE UPDATE OR INSERT ON metabib.title_field_entry
-	FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
+	FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('title');
 
 CREATE INDEX metabib_title_field_entry_index_vector_idx ON metabib.title_field_entry USING GIST (index_vector);
 
@@ -35,7 +35,7 @@ CREATE TABLE metabib.author_field_entry (
 );
 CREATE TRIGGER metabib_author_field_entry_fti_trigger
 	BEFORE UPDATE OR INSERT ON metabib.author_field_entry
-	FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
+	FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('author');
 
 CREATE INDEX metabib_author_field_entry_index_vector_idx ON metabib.author_field_entry USING GIST (index_vector);
 
@@ -49,7 +49,7 @@ CREATE TABLE metabib.subject_field_entry (
 );
 CREATE TRIGGER metabib_subject_field_entry_fti_trigger
 	BEFORE UPDATE OR INSERT ON metabib.subject_field_entry
-	FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
+	FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('subject');
 
 CREATE INDEX metabib_subject_field_entry_index_vector_idx ON metabib.subject_field_entry USING GIST (index_vector);
 
@@ -63,7 +63,7 @@ CREATE TABLE metabib.keyword_field_entry (
 );
 CREATE TRIGGER metabib_keyword_field_entry_fti_trigger
 	BEFORE UPDATE OR INSERT ON metabib.keyword_field_entry
-	FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
+	FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('keyword');
 
 CREATE INDEX metabib_keyword_field_entry_index_vector_idx ON metabib.keyword_field_entry USING GIST (index_vector);
 
@@ -77,7 +77,7 @@ CREATE TABLE metabib.series_field_entry (
 );
 CREATE TRIGGER metabib_series_field_entry_fti_trigger
 	BEFORE UPDATE OR INSERT ON metabib.series_field_entry
-	FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
+	FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('series');
 
 CREATE INDEX metabib_series_field_entry_index_vector_idx ON metabib.series_field_entry USING GIST (index_vector);
 
@@ -131,7 +131,7 @@ CREATE TABLE metabib.full_rec (
 CREATE INDEX metabib_full_rec_record_idx ON metabib.full_rec (record);
 CREATE TRIGGER metabib_full_rec_fti_trigger
 	BEFORE UPDATE OR INSERT ON metabib.full_rec
-	FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
+	FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('default');
 
 CREATE INDEX metabib_full_rec_index_vector_idx ON metabib.full_rec USING GIST (index_vector);
 
-- 
2.43.2