From 2d2e504c633ed30557324acf5ecff7971e68d581 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Tue, 25 Mar 2014 13:59:55 -0400 Subject: [PATCH] LP1297435: Make 0872 upgrade require less hand holding. Add a count() around the metabib.remap_metarecord_for_bib call in the final select statement. This allows the script to run without the user having to scroll through rows of output. Signed-off-by: Jason Stephenson Signed-off-by: Ben Shum --- .../upgrade/0872.functions.metarecord-deleted-constituents.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0872.functions.metarecord-deleted-constituents.sql b/Open-ILS/src/sql/Pg/upgrade/0872.functions.metarecord-deleted-constituents.sql index b32c4b2620..ca92d26df4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0872.functions.metarecord-deleted-constituents.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0872.functions.metarecord-deleted-constituents.sql @@ -345,7 +345,7 @@ END; $F$ LANGUAGE PLPGSQL STABLE; -- Forcibly remap deleted master records, retaining the linkage if so configured. -SELECT metabib.remap_metarecord_for_bib( bre.id, bre.fingerprint, TRUE, COALESCE(flag.enabled,FALSE)) +SELECT count(metabib.remap_metarecord_for_bib( bre.id, bre.fingerprint, TRUE, COALESCE(flag.enabled,FALSE))) FROM metabib.metarecord metar JOIN biblio.record_entry bre ON bre.id = metar.master_record, config.internal_flag flag -- 2.43.2