Kouhei Sutou
null+****@clear*****
Mon Jun 5 00:17:06 JST 2017
Kouhei Sutou 2017-06-05 00:17:06 +0900 (Mon, 05 Jun 2017) New Revision: 8eeb2b04eb973c8fa8868cea74e337e682efa043 https://github.com/pgroonga/pgroonga/commit/8eeb2b04eb973c8fa8868cea74e337e682efa043 Message: Fix order Modified files: data/pgroonga--1.2.0--1.2.1.sql Modified: data/pgroonga--1.2.0--1.2.1.sql (+11 -10) =================================================================== --- data/pgroonga--1.2.0--1.2.1.sql 2017-06-05 00:15:15 +0900 (81c3e9e) +++ data/pgroonga--1.2.0--1.2.1.sql 2017-06-05 00:17:06 +0900 (6274a57) @@ -1,3 +1,14 @@ +-- Update amstrategies for old PostgreSQL +DO LANGUAGE plpgsql $$ +BEGIN + SELECT amstrategies FROM pg_am LIMIT 0; +EXCEPTION + WHEN syntax_error THEN + UPDATE pg_am SET amstrategies = 27 + WHERE amname = 'pgroonga'; +END; +$$; + -- Update pgroonga.text_full_text_search_ops_v2 DROP OPERATOR CLASS pgroonga.text_full_text_search_ops_v2 USING pgroonga; DROP OPERATOR &@> (text, text[]); @@ -365,16 +376,6 @@ CREATE OPERATOR CLASS pgroonga.text_array_term_search_ops_v2 FOR TYPE text[] -- Add pgroonga.text_regexp_ops_v2. -- Add pgroonga.varchar_regexp_ops_v2. -DO LANGUAGE plpgsql $$ -BEGIN - SELECT amstrategies FROM pg_am LIMIT 0; -EXCEPTION - WHEN syntax_error THEN - UPDATE pg_am SET amstrategies = 27 - WHERE amname = 'pgroonga'; -END; -$$; - CREATE FUNCTION pgroonga.regexp_text(text, text) RETURNS bool AS 'MODULE_PATHNAME', 'pgroonga_regexp_text' -------------- next part -------------- HTML����������������������������... Download