Kouhei Sutou
null+****@clear*****
Tue Aug 15 00:46:45 JST 2017
Kouhei Sutou 2017-08-15 00:46:45 +0900 (Tue, 15 Aug 2017) New Revision: 5a17fcbe2322a7eb6591628e162c29d525199193 https://github.com/pgroonga/pgroonga/commit/5a17fcbe2322a7eb6591628e162c29d525199193 Message: Fix upgrade failure on PostgreSQL 9.6 or later Modified files: data/pgroonga--1.2.0--1.2.1.sql data/pgroonga--1.2.1--1.2.2.sql Modified: data/pgroonga--1.2.0--1.2.1.sql (+3 -4) =================================================================== --- data/pgroonga--1.2.0--1.2.1.sql 2017-08-13 01:28:49 +0900 (6274a57) +++ data/pgroonga--1.2.0--1.2.1.sql 2017-08-15 00:46:45 +0900 (7f7f8bd) @@ -1,11 +1,10 @@ -- Update amstrategies for old PostgreSQL DO LANGUAGE plpgsql $$ BEGIN - SELECT amstrategies FROM pg_am LIMIT 0; + UPDATE pg_am SET amstrategies = 27 + WHERE amname = 'pgroonga'; EXCEPTION - WHEN syntax_error THEN - UPDATE pg_am SET amstrategies = 27 - WHERE amname = 'pgroonga'; + WHEN undefined_column THEN -- Ignore END; $$; Modified: data/pgroonga--1.2.1--1.2.2.sql (+3 -4) =================================================================== --- data/pgroonga--1.2.1--1.2.2.sql 2017-08-13 01:28:49 +0900 (e624fa2) +++ data/pgroonga--1.2.1--1.2.2.sql 2017-08-15 00:46:45 +0900 (9aba2ae) @@ -19,11 +19,10 @@ ALTER OPERATOR FAMILY pgroonga.text_term_search_ops_v2 USING pgroonga -- Update amstrategies for old PostgreSQL DO LANGUAGE plpgsql $$ BEGIN - SELECT amstrategies FROM pg_am LIMIT 0; + UPDATE pg_am SET amstrategies = 30 + WHERE amname = 'pgroonga'; EXCEPTION - WHEN syntax_error THEN - UPDATE pg_am SET amstrategies = 30 - WHERE amname = 'pgroonga'; + WHEN undefined_column THEN -- Ignore END; $$; -------------- next part -------------- HTML����������������������������...Download