From dc4280bc3e44aef6154efda1bf3d4b423022cb94 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 2 Dec 2011 07:56:18 -0500 Subject: [PATCH] adding edit to have long-running function only update non-deleted call_numbers (thanks dbs!) --- 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 cb1a4d254d..426df93c10 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 @@ -5672,7 +5672,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