From c45c44538eedff67277d35c636ffd052e2b41f7d Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 2 Mar 2015 14:20:55 +0000 Subject: [PATCH] LP#1155313: recalculate normalized labels during upgrade Signed-off-by: Galen Charlton --- .../0914.schema.redo_vandelay_merge_profile_sequence.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/0914.schema.redo_vandelay_merge_profile_sequence.sql b/Open-ILS/src/sql/Pg/upgrade/0914.schema.redo_vandelay_merge_profile_sequence.sql index 2002771ded..2d2d1f7696 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0914.schema.redo_vandelay_merge_profile_sequence.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0914.schema.redo_vandelay_merge_profile_sequence.sql @@ -19,3 +19,7 @@ $$ LANGUAGE PLPERLU; COMMIT; +-- recompute the various normalized label fields that use lpad_number_substrings() +UPDATE biblio.monograph_part SET id = id; +UPDATE asset.call_number_prefix SET id = id; +UPDATE asset.call_number_suffix SET id = id; -- 2.43.2