From cf034cba0465f1f015b0846a845b7043523728f7 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 5 Apr 2011 15:29:34 -0400 Subject: [PATCH] Remove multi-homed items on record "delete" --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 68ba313..9a42d89 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -950,6 +950,7 @@ BEGIN DELETE FROM metabib.metarecord_source_map WHERE source = NEW.id; -- Rid ourselves of the search-estimate-killing linkage DELETE FROM metabib.record_attr WHERE id = NEW.id; -- Kill the attrs hash, useless on deleted records DELETE FROM authority.bib_linking WHERE bib = NEW.id; -- Avoid updating fields in bibs that are no longer visible + DELETE FROM biblio.peer_bib_copy_map WHERE peer_record = NEW.id; -- Separate any multi-homed items RETURN NEW; -- and we're done END IF; -- 1.7.2.5