From 5d41d16483c77b91d4b494444e27593a955b250c Mon Sep 17 00:00:00 2001 From: Dan Scott 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 Signed-off-by: Thomas Berezansky --- 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.43.2