From 72d18605e91a9a5f4f8c741aafbc346f8fb0f7cc Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 13 Sep 2012 07:28:50 -0400 Subject: [PATCH] make sure all our bibs know they're unicode --- .../src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql index a3b72891a1..ab8d516426 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql @@ -3,5 +3,14 @@ -- remove replication schema DROP SCHEMA _replication CASCADE; +-- disable triggers on biblio.record_entry to do an update +ALTER TABLE biblio.record_entry DISABLE TRIGGER ALL; + +UPDATE biblio.record_entry + SET marc = regexp_replace(marc, E'(.{9}).', E'\\1a'); + +ALTER TABLE biblio.record_entry ENABLE TRIGGER ALL; + -- disable triggers on asset.copy ALTER TABLE asset.copy DISABLE TRIGGER ALL; + -- 2.11.0