From 89fe7e5c901d3261441c92c6733d0cd55195bd72 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 4 Jun 2018 13:10:31 -0400 Subject: [PATCH] LP#1764542 - Update older sites to MODS 3.3 MODS 3.3 support was introduced in March 2009, but this change was never included in an upgrade script. Older sites will need to apply this update to avoid scary segmentation faults, and it shouls be harmless for newer sites. Signed-off-by: Chris Sharp --- .../sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql new file mode 100644 index 0000000000..106407bfcf --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql @@ -0,0 +1,11 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +-- Thanks to Bill Ott for sharing his update +UPDATE config.metabib_field SET xpath=regexp_replace(xpath,'mods32','mods33','g') WHERE xpath ~ 'mods32'; +UPDATE config.metabib_field SET format = 'mods33' WHERE format = 'mods32'; +ALTER TABLE config.metabib_field ALTER COLUMN format SET DEFAULT 'mods33'::text; + +COMMIT; + -- 2.11.0