From 512400e63a3cb5362545b7ca0cc9729ac628774a 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 --- Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql index cbb6f71c2b..a3a8560c7c 100644 --- a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql @@ -5998,7 +5998,7 @@ $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 asset.call_number SET id = id WHERE deleted IS FALSE OR deleted = FALSE; -- 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 -- 2.43.2