From 8e5dc73ba37421898f3d5d8bfa0e35b74715d8de Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Tue, 18 Mar 2014 21:15:25 -0400 Subject: [PATCH] LP#1243023: Add optional quick reingest to upgrade script Signed-off-by: Dan Wells Signed-off-by: Ben Shum --- .../Pg/upgrade/XXXX.function.oils_xpath-tweaks-for-newer-pg.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.oils_xpath-tweaks-for-newer-pg.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.oils_xpath-tweaks-for-newer-pg.sql index 14cd1a02ef..d017e75d5e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.oils_xpath-tweaks-for-newer-pg.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.oils_xpath-tweaks-for-newer-pg.sql @@ -601,3 +601,11 @@ END; $func$ LANGUAGE PLPGSQL; COMMIT; + +\qecho This script will now attempt a "quick fix" of browse_entry only. +\qecho If you have issues, a browse or full reingest is recommended. +\qecho You may cancel now without losing the effect of the rest of the +\qecho upgrade script, and arrange the reingest later. + +UPDATE metabib.browse_entry SET value=evergreen.xml_famous5_to_text(value) WHERE value LIKE '%&%'; +UPDATE metabib.browse_entry SET sort_value=evergreen.xml_famous5_to_text(sort_value) WHERE sort_value LIKE '%&%'; -- 2.11.0