From 24b99f9bc8c566f3fe1d589ccadda819b76b9279 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Tue, 22 Nov 2011 12:00:06 -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 7e874d87f8..1acebc3ba0 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 @@ -5669,7 +5669,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.11.0