From 2809205a0cbe6effc19a3873cb0c67e77ea216cc 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 --- 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 4c9686f82b..facd386047 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