[Groonga-commit] pgroonga/pgroonga at 37d62c4 [master] Add missing amstrategies update for PostgreSQL < 9.6

Back to archive index

Kouhei Sutou null+****@clear*****
Mon Jul 3 12:29:24 JST 2017


Kouhei Sutou	2017-07-03 12:29:24 +0900 (Mon, 03 Jul 2017)

  New Revision: 37d62c4e7c4ceece0b2d066dfe3f45b608ed362f
  https://github.com/pgroonga/pgroonga/commit/37d62c4e7c4ceece0b2d066dfe3f45b608ed362f

  Message:
    Add missing amstrategies update for PostgreSQL < 9.6

  Modified files:
    data/pgroonga--1.2.1--1.2.2.sql

  Modified: data/pgroonga--1.2.1--1.2.2.sql (+11 -0)
===================================================================
--- data/pgroonga--1.2.1--1.2.2.sql    2017-07-03 12:24:06 +0900 (412f353)
+++ data/pgroonga--1.2.1--1.2.2.sql    2017-07-03 12:29:24 +0900 (e624fa2)
@@ -16,6 +16,17 @@ ALTER OPERATOR FAMILY pgroonga.text_term_search_ops_v2 USING pgroonga
 		OPERATOR 4 >= (text, text),
 		OPERATOR 5 > (text, text);
 
+-- 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 = 30
+		 WHERE amname = 'pgroonga';
+END;
+$$;
+
 -- &? -> &@~
 -- &~? -> &@*
 -- &?| -> &@~|
-------------- next part --------------
HTML����������������������������...
下載 



More information about the Groonga-commit mailing list
Back to archive index