From 5d41d16483c77b91d4b494444e27593a955b250c Mon Sep 17 00:00:00 2001
From: Dan Scott <dscott@laurentian.ca>
Date: Sat, 22 Sep 2012 16:35:43 -0400
Subject: [PATCH] Add support for PostgreSQL 9.2, drop TSearch2 extension

The TSearch2 extension hasn't been needed for a long time, and it causes
problems trying to use ts_rewrite(TSQUERY, TEXT) at least.

Add a full text search config script for PostgreSQL 9.2.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
---
 Open-ILS/src/sql/Pg/000.english.pg92.fts-config.sql | 1 +
 Open-ILS/src/sql/Pg/create_database_contribs.sql    | 2 --
 Open-ILS/src/sql/Pg/create_database_extensions.sql  | 2 --
 3 files changed, 1 insertion(+), 4 deletions(-)
 create mode 120000 Open-ILS/src/sql/Pg/000.english.pg92.fts-config.sql

diff --git a/Open-ILS/src/sql/Pg/000.english.pg92.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg92.fts-config.sql
new file mode 120000
index 0000000000..fd3fe587ae
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/000.english.pg92.fts-config.sql
@@ -0,0 +1 @@
+000.english.pg90.fts-config.sql
\ No newline at end of file
diff --git a/Open-ILS/src/sql/Pg/create_database_contribs.sql b/Open-ILS/src/sql/Pg/create_database_contribs.sql
index aec933e708..49acaa93af 100644
--- a/Open-ILS/src/sql/Pg/create_database_contribs.sql
+++ b/Open-ILS/src/sql/Pg/create_database_contribs.sql
@@ -22,8 +22,6 @@ CREATE LANGUAGE plperlu;
 -- So we \set to a single variable, then use that single variable with \i
 \set load_file :contrib_dir/tablefunc.sql
 \i :load_file
-\set load_file :contrib_dir/tsearch2.sql
-\i :load_file
 \set load_file :contrib_dir/pgxml.sql
 \i :load_file
 \set load_file :contrib_dir/hstore.sql
diff --git a/Open-ILS/src/sql/Pg/create_database_extensions.sql b/Open-ILS/src/sql/Pg/create_database_extensions.sql
index dd6066fbbf..e06ac598b9 100644
--- a/Open-ILS/src/sql/Pg/create_database_extensions.sql
+++ b/Open-ILS/src/sql/Pg/create_database_extensions.sql
@@ -14,10 +14,8 @@ CREATE DATABASE :db_name TEMPLATE template0 ENCODING 'UNICODE' LC_COLLATE 'C' LC
 
 \connect :db_name
 
---CREATE LANGUAGE plperl;
 CREATE LANGUAGE plperlu;
 
 CREATE EXTENSION tablefunc;
-CREATE EXTENSION tsearch2;
 CREATE EXTENSION xml2;
 CREATE EXTENSION hstore;
-- 
2.11.0