From 3b3af0e301b1a1748f83cd52600ac93cb781dcd3 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 8 Dec 2011 14:19:28 -0500 Subject: [PATCH] correcting the XML namespace so xpath will work in config.metabib_field --- Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql b/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql index 2fd44ae061..11aee7c846 100644 --- a/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql +++ b/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql @@ -196,6 +196,17 @@ INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, COMMIT; +-- change the namespace in the xpath field to "marc:" to match what's expected in 1.6-2.1: + +BEGIN; + +UPDATE config.metabib_field + SET xpath = regexp_replace(xpath, E'/(marcxml):subfield', E'/marc:subfield'); +UPDATE config.metabib_field + SET xpath = regexp_replace(xpath, E'/(marcxml):', E'/marc:'); + +COMMIT; + -- we need to tell Evergreen that every record we have in the system is a Unicode record: -- disable triggers on biblio.record_entry and authority.record_entry: -- 2.11.0