From 19ce9376cd16921c63e89fec61881f85eff97614 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 1 Sep 2017 17:22:42 -0400 Subject: [PATCH] LP#1152753: fix fake FK trigger on vandelay.import_item Fixes a regression caught by live_t/0824.item_import_defaults.pg Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/800.fkeys.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/800.fkeys.sql b/Open-ILS/src/sql/Pg/800.fkeys.sql index 8ae7d2647d..1ee6ead440 100644 --- a/Open-ILS/src/sql/Pg/800.fkeys.sql +++ b/Open-ILS/src/sql/Pg/800.fkeys.sql @@ -110,6 +110,9 @@ ALTER TABLE serial.unit ADD CONSTRAINT serial_unit_editor_fkey FOREIGN KEY (edit CREATE OR REPLACE FUNCTION evergreen.vandelay_import_item_imported_as_inh_fkey() RETURNS TRIGGER AS $f$ BEGIN + IF NEW.imported_as IS NULL THEN + RETURN NEW; + END IF; PERFORM 1 FROM asset.copy WHERE id = NEW.imported_as; IF NOT FOUND THEN RAISE foreign_key_violation USING MESSAGE = FORMAT( -- 2.11.0