LP1744341 Hold targeter --retarget-frozen - upgrade script user/stompro/lp1744341-retarget-frozen-holds-v3-withupgrade
authorJosh Stompro <stomproj@larl.org>
Thu, 2 Mar 2023 18:12:17 +0000 (12:12 -0600)
committerJosh Stompro <stomproj@larl.org>
Thu, 2 Mar 2023 18:12:17 +0000 (12:12 -0600)
commitfdb4c2e009b40e802ca4d6d86f50a6bda39cde2c
tree37be0ed1b004838c18a20110ad25dc642bdd501e
parent83c45024f038638da89424722d04b605315ab73a
LP1744341 Hold targeter --retarget-frozen - upgrade script

Side effect is that frozen holds get checked to see if they are expired.
Normally expire_time is unset when a hold is frozen, but there may have
been some bugs in the past that have allowed frozen holds to have it set.

This will just fix those so no holds get unexpectedly canceled when the
new option is used.

Signed-off-by: Josh Stompro <stomproj@larl.org>
Open-ILS/src/sql/Pg/upgrade/xxxx.data.lp1744341.frozen_hold_remove_expire.sql [new file with mode: 0644]