Open-ILS/src/sql/Pg/upgrade/1303.schema.authority-full-rec-value-index.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('1303', :eg_version);
   4
   5 DROP INDEX authority.authority_full_rec_value_index;
   6 CREATE INDEX authority_full_rec_value_index ON authority.full_rec (SUBSTRING(value FOR 1024));
   7
   8 DROP INDEX authority.authority_full_rec_value_tpo_index;
   9 CREATE INDEX authority_full_rec_value_tpo_index ON authority.full_rec (SUBSTRING(value FOR 1024) text_pattern_ops);
  10
  11
  12 COMMIT;