From c0fd42b615445c74723b7084d3dd75024442367b Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 4 May 2015 18:25:53 -0400 Subject: [PATCH] LP#1445150: Create 000.english.pg94.fts-config.sql We need this file so that the eg_db_config script can make the Evergreen database on PostgreSQL 9.4 systems. Signed-off-by: Ben Shum --- .../src/sql/Pg/000.english.pg94.fts-config.sql | 57 ++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/000.english.pg94.fts-config.sql diff --git a/Open-ILS/src/sql/Pg/000.english.pg94.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg94.fts-config.sql new file mode 100644 index 0000000000..8bae23e091 --- /dev/null +++ b/Open-ILS/src/sql/Pg/000.english.pg94.fts-config.sql @@ -0,0 +1,57 @@ +/* + * Copyright (C) 2004-2008 Georgia Public Library Service + * Copyright (C) 2008 Equinox Software, Inc., Laurentian University + * Mike Rylander + * Dan Scott + * + * This program is free software; you can redistribute it and/or + * modify it under the terms of the GNU General Public License + * as published by the Free Software Foundation; either version 2 + * of the License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + */ + +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); + RETURN NEW; +END; +$$ LANGUAGE PLPGSQL; + +DO $$ +DECLARE +lang TEXT; +BEGIN +FOR lang IN SELECT substring(pptsd.dictname from '(.*)_stem$') AS lang FROM pg_catalog.pg_ts_dict pptsd JOIN pg_catalog.pg_namespace ppn ON ppn.oid = pptsd.dictnamespace +WHERE ppn.nspname = 'pg_catalog' AND pptsd.dictname LIKE '%_stem' LOOP +RAISE NOTICE 'FOUND LANGUAGE %', lang; + +EXECUTE 'DROP TEXT SEARCH DICTIONARY IF EXISTS ' || lang || '_nostop CASCADE; +CREATE TEXT SEARCH DICTIONARY ' || lang || '_nostop (TEMPLATE=pg_catalog.snowball, language=''' || lang || '''); +COMMENT ON TEXT SEARCH DICTIONARY ' || lang || '_nostop IS ''' ||lang || ' snowball stemmer with no stopwords for ASCII words only.''; +CREATE TEXT SEARCH CONFIGURATION ' || lang || '_nostop ( COPY = pg_catalog.' || lang || ' ); +ALTER TEXT SEARCH CONFIGURATION ' || lang || '_nostop ALTER MAPPING FOR word, hword, hword_part WITH pg_catalog.simple; +ALTER TEXT SEARCH CONFIGURATION ' || lang || '_nostop ALTER MAPPING FOR asciiword, asciihword, hword_asciipart WITH ' || lang || '_nostop;'; + +END LOOP; +END; +$$; +CREATE TEXT SEARCH CONFIGURATION title ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION author ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION subject ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION keyword ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION identifier ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION series ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION "default" ( COPY = english_nostop ); + + +COMMIT; -- 2.11.0