3 SELECT evergreen.upgrade_deps_block_check('1075', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.vandelay_import_item_imported_as_inh_fkey() RETURNS TRIGGER AS $f$
7 IF NEW.imported_as IS NULL THEN
10 PERFORM 1 FROM asset.copy WHERE id = NEW.imported_as;
12 RAISE foreign_key_violation USING MESSAGE = FORMAT(
13 $$Referenced asset.copy id not found, imported_as:%s$$, NEW.imported_as
18 $f$ LANGUAGE PLPGSQL VOLATILE COST 50;