Open-ILS/src/sql/Pg/upgrade/XXXX.schema.staged_search_cleanup.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
   4
   5 DROP FUNCTION search.query_parser_fts (
   6     INT,
   7     INT,
   8     TEXT,
   9     INT[],
  10     INT[],
  11     INT,
  12     INT,
  13     INT,
  14     BOOL,
  15     BOOL,
  16     BOOL,
  17     INT
  18 );
  19
  20 DROP TABLE asset.opac_visible_copies;
  21
  22 DROP FUNCTION IF EXISTS asset.refresh_opac_visible_copies_mat_view();
  23
  24 COMMIT;