From 9209f1153260c63c848a3c50d37d79fa5966da06 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 6 Jul 2018 13:04:59 -0400 Subject: [PATCH] Add SQL insert checks in search-index-keep-periods Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/search-index-keep-periods.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/KCLS/sql/schema/deploy/search-index-keep-periods.sql b/KCLS/sql/schema/deploy/search-index-keep-periods.sql index 8407daa0ae..19fef360be 100644 --- a/KCLS/sql/schema/deploy/search-index-keep-periods.sql +++ b/KCLS/sql/schema/deploy/search-index-keep-periods.sql @@ -3,6 +3,10 @@ BEGIN; +DO $INSERT$ +BEGIN + IF evergreen.insert_on_deploy() THEN + INSERT INTO config.metabib_field (field_class, name, label, xpath, weight, format, search_field, browse_field) VALUES ( @@ -91,6 +95,10 @@ VALUES ( ); + END IF; -- insert_on_deploy +END $INSERT$; + + CREATE OR REPLACE FUNCTION biblio.extract_metabib_field_entry ( rid BIGINT, default_joiner TEXT ) RETURNS SETOF metabib.field_entry_template AS $func$ DECLARE bib biblio.record_entry%ROWTYPE; -- 2.11.0