From 0e3625589013c41c08ce7e9731b2fa56d7c72f99 Mon Sep 17 00:00:00 2001 From: dbs Date: Mon, 25 Aug 2008 17:49:56 +0000 Subject: [PATCH 1/1] Enable LIKE to use an index for authority.full_rec.value (on database clusters with a locale other than C or POSIX) git-svn-id: svn://svn.open-ils.org/ILS/trunk@10440 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 2 ++ Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql | 2 ++ 2 files changed, 4 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index 6ffc574904..b0e168f231 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -76,6 +76,8 @@ CREATE TRIGGER authority_full_rec_fti_trigger FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); CREATE INDEX authority_full_rec_index_vector_idx ON authority.full_rec USING GIST (index_vector); +/* Enable LIKE to use an index for database clusters with locales other than C or POSIX */ +CREATE INDEX authority_full_rec_value_tpo_index ON authority.full_rec (value text_pattern_ops); CREATE OR REPLACE VIEW authority.tracing_links AS SELECT main.record AS record, diff --git a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql new file mode 100644 index 0000000000..3da5b0d0b3 --- /dev/null +++ b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql @@ -0,0 +1,2 @@ +/* Enable LIKE to use an index for database clusters with locales other than C or POSIX */ +CREATE INDEX authority_full_rec_value_tpo_index ON authority.full_rec (value text_pattern_ops); -- 2.43.2