fixes issue 34650: Ability to create indexes to speed up 'contains' search
authorCarlos Aristu <carlos.aristu@openbravo.com>
Wed, 11 Jan 2017 09:15:48 +0100
changeset 31459 b3923337f9a6
parent 31458 53870f5306ea
child 31466 5b206910eb99
fixes issue 34650: Ability to create indexes to speed up 'contains' search
src-db/database/lib/dbsourcemanager.jar
src-db/database/model/excludeFilter.xml
src-db/database/model/prescript-PostgreSql.sql
Binary file src-db/database/lib/dbsourcemanager.jar has changed
--- a/src-db/database/model/excludeFilter.xml	Tue Jan 10 10:29:27 2017 +0100
+++ b/src-db/database/model/excludeFilter.xml	Wed Jan 11 09:15:48 2017 +0100
@@ -67,4 +67,23 @@
     <excludedFunction name="ADD_HMS"/>
     <excludedFunction name="PG\_%"/> <!-- PostgreSQL extension functions -->
     <excludedTrigger name="AU\_%"/> <!-- Audit trail triggers -->
+    <excludedFunction name="GIN_EXTRACT_QUERY_TRGM"/>
+    <excludedFunction name="GIN_EXTRACT_VALUE_TRGM"/>
+    <excludedFunction name="GIN_TRGM_CONSISTENT"/>
+    <excludedFunction name="GTRGM_COMPRESS"/>
+    <excludedFunction name="GTRGM_CONSISTENT"/>
+    <excludedFunction name="GTRGM_DECOMPRESS"/>
+    <excludedFunction name="GTRGM_DISTANCE"/>
+    <excludedFunction name="GTRGM_IN"/>
+    <excludedFunction name="GTRGM_OUT"/>
+    <excludedFunction name="GTRGM_PENALTY"/>
+    <excludedFunction name="GTRGM_PICKSPLIT"/>
+    <excludedFunction name="GTRGM_SAME"/>
+    <excludedFunction name="GTRGM_UNION"/>
+    <excludedFunction name="SET_LIMIT"/>
+    <excludedFunction name="SHOW_LIMIT"/>
+    <excludedFunction name="SHOW_TRGM"/>
+    <excludedFunction name="SIMILARITY"/>
+    <excludedFunction name="SIMILARITY_DIST"/>
+    <excludedFunction name="SIMILARITY_OP"/>
   </vector>
--- a/src-db/database/model/prescript-PostgreSql.sql	Tue Jan 10 10:29:27 2017 +0100
+++ b/src-db/database/model/prescript-PostgreSql.sql	Wed Jan 11 09:15:48 2017 +0100
@@ -1184,6 +1184,7 @@
 RETURNS uuid
 AS '$libdir/uuid-ossp', 'uuid_generate_v4'
 VOLATILE STRICT LANGUAGE C;
+/-- END
 
 CREATE OR REPLACE FUNCTION get_uuid()
   RETURNS varchar AS
@@ -1531,3 +1532,7 @@
 END ; $BODY$
   LANGUAGE plpgsql IMMUTABLE
 /-- END
+
+-- INSTALL PG_TRGM EXTENSION
+CREATE EXTENSION IF NOT EXISTS "pg_trgm"
+/-- END