From 0161aef74694648a57307915157469246947e9d1 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 1 Sep 2017 17:26:32 -0400 Subject: [PATCH] LP#1152753: upgrade script Signed-off-by: Galen Charlton Signed-off-by: Mike Rylander --- .../sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql new file mode 100644 index 0000000000..8c2b1e4bb3 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql @@ -0,0 +1,19 @@ +BEGIN; + +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( + $$Referenced asset.copy id not found, imported_as:%s$$, NEW.imported_as + ); + END IF; + RETURN NEW; +END; +$f$ LANGUAGE PLPGSQL VOLATILE COST 50; + + +COMMIT; -- 2.11.0