From 9704da106f62a8a338f3a7166ecab27ec759cbd7 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 17 Mar 2010 19:14:39 +0000 Subject: [PATCH] upgrade scrip version of r15879: delete the metarecord link for "deleted" records git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_0@15880 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql index e0732866de..ad773dd0ff 100644 --- a/Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql @@ -20,6 +20,9 @@ BEGIN; INSERT INTO config.upgrade_log(version) VALUES ('1.6.0.4'); +-- remove the metarecord link for "deleted" records +CREATE OR REPLACE RULE protect_bib_rec_delete AS ON DELETE TO biblio.record_entry DO INSTEAD (UPDATE biblio.record_entry SET deleted = TRUE WHERE OLD.id = biblio.record_entry.id; DELETE FROM metabib.metarecord_source_map WHERE source = OLD.id); + -- Match ingest fixes for leading / trailing whitespace on ISSNs and date ranges UPDATE metabib.real_full_rec SET value = TRIM(value) -- 2.11.0