Open-ILS/src/sql/Pg/upgrade/0747.data.frozen_holds_clear_expire_time.sql

   1 -- LP1076399: Prevent reactivated holds from canceling immediately.
   2 -- Set the expire_time to NULL on all frozen/suspended holds.
   3 BEGIN;
   4
   5 SELECT evergreen.upgrade_deps_block_check('0747', :eg_version);
   6
   7 UPDATE action.hold_request
   8 SET expire_time = NULL
   9 WHERE frozen = 't';
  10
  11 COMMIT;