From abb4b98b964c1240d17f05358ed9d1888a9c6c0e Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 1 Nov 2011 16:17:59 -0400 Subject: [PATCH] pin upgrade script Signed-off-by: Jason Etheridge --- ....null_svf_protection.sql => 0645.schema.null_svf_protection.sql} | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.null_svf_protection.sql => 0645.schema.null_svf_protection.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.null_svf_protection.sql b/Open-ILS/src/sql/Pg/upgrade/0645.schema.null_svf_protection.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.null_svf_protection.sql rename to Open-ILS/src/sql/Pg/upgrade/0645.schema.null_svf_protection.sql index 610de9df14..e448ede689 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.null_svf_protection.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0645.schema.null_svf_protection.sql @@ -1,3 +1,6 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0645'); CREATE OR REPLACE FUNCTION biblio.indexing_ingest_or_delete () RETURNS TRIGGER AS $func$ DECLARE @@ -120,7 +123,7 @@ BEGIN IF TG_OP = 'INSERT' OR OLD.deleted THEN -- initial insert OR revivication INSERT INTO metabib.record_attr (id, attrs) VALUES (NEW.id, new_attrs); ELSE - UPDATE metabib.record_attr SET attrs = new_attrs WHERE id = NEW.id; + UPDATE metabib.record_attr SET attrs = attrs || new_attrs WHERE id = NEW.id; END IF; END IF; @@ -159,3 +162,4 @@ BEGIN END; $func$ LANGUAGE PLPGSQL; +COMMIT; -- 2.11.0