X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/be71a8600fc889060bed19fa5ef24938ab99b14b..fdebfd5d0c558cb156849b01c9c9268b29dc443b:/sql/Pg-upgrade2/trigram_indices.sql diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql index 7303450be..d240d80a7 100644 --- a/sql/Pg-upgrade2/trigram_indices.sql +++ b/sql/Pg-upgrade2/trigram_indices.sql @@ -1,10 +1,6 @@ -- @tag: trigram_indices -- @description: Trigram Indizes für häufig durchsuchte Spalten --- @depends: release_3_4_1 --- @encoding: utf-8 --- @may_fail: 1 - -CREATE EXTENSION IF NOT EXISTS pg_trgm; +-- @depends: release_3_5_0 trigram_extension CREATE INDEX customer_customernumber_gin_trgm_idx ON customer USING gin (customernumber gin_trgm_ops); CREATE INDEX customer_name_gin_trgm_idx ON customer USING gin (name gin_trgm_ops);