From 20a6185001d99f486040039ec73d2b6775ade4b9 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Tue, 22 Nov 2011 11:55:45 -0500 Subject: [PATCH] Avoid updating deleted call numbers for 2.0 -> 2.1 upgrade 25% of the call numbers on our production system are deleted, so filtering out the deleted call numbers from the update in the 2.0 -> 2.1 upgrade saves a significant amount of time. Signed-off-by: Dan Scott Signed-off-by: Bill Erickson Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql index 7e874d87f8..92d7dd3c0c 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql @@ -5669,8 +5669,6 @@ $func$ LANGUAGE plpgsql; -- 0505 UPDATE metabib.facet_entry SET value = evergreen.force_unicode_normal_form(value,'NFC'); -UPDATE asset.call_number SET id = id; - -- Update reporter.materialized_simple_record with normalized ISBN values -- This might not get all of them, but most ISBNs will have more than one hyphen DELETE FROM reporter.materialized_simple_record WHERE id IN ( @@ -8855,6 +8853,7 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 513, 'DEBUG_CLIENT', oils_i18n_gettext( 513, 'Allows a user to use debug functions in the staff client', 'ppl', 'description' )); +UPDATE asset.call_number SET id = id WHERE deleted IS FALSE OR deleted = FALSE; -- 0529 INSERT INTO config.org_unit_setting_type -- 2.11.0