Open-ILS/src/sql/Pg/upgrade/1075.schema.fix_vii_fake_fkey.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('1075', :eg_version);
   4
   5 CREATE OR REPLACE FUNCTION evergreen.vandelay_import_item_imported_as_inh_fkey() RETURNS TRIGGER AS $f$
   6 BEGIN
   7         IF NEW.imported_as IS NULL THEN
   8                 RETURN NEW;
   9         END IF;
  10         PERFORM 1 FROM asset.copy WHERE id = NEW.imported_as;
  11         IF NOT FOUND THEN
  12                 RAISE foreign_key_violation USING MESSAGE = FORMAT(
  13                         $$Referenced asset.copy id not found, imported_as:%s$$, NEW.imported_as
  14                 );
  15         END IF;
  16         RETURN NEW;
  17 END;
  18 $f$ LANGUAGE PLPGSQL VOLATILE COST 50;
  19
  20
  21 COMMIT;