From 1bff2b42413d1fb771fed1d4d1dca920d76b5a3a Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Thu, 9 Nov 2017 09:55:42 -0500 Subject: [PATCH] LP1731281: Remove Deleted Items From acvac Table The script that created the acvac table accidentally included entries for deleted items which leads to confusion when titles the library no longer owns are displayed as available again, even though no copies appear on the record detail page. This upgrade script removes any that are left there. Signed-off-by: Jason Boyer Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1731281-acvac-cleanup.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1731281-acvac-cleanup.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1731281-acvac-cleanup.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1731281-acvac-cleanup.sql new file mode 100644 index 0000000000..e7bd8f9885 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1731281-acvac-cleanup.sql @@ -0,0 +1,7 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +DELETE FROM asset.copy_vis_attr_cache WHERE target_copy IN (SELECT id FROM asset.copy WHERE deleted); + +COMMIT; -- 2.11.0