3 SELECT evergreen.upgrade_deps_block_check('1081', :eg_version); -- jboyer/gmcharlt
5 DROP TRIGGER IF EXISTS inherit_copy_bucket_item_target_copy_fkey ON container.copy_bucket_item;
6 DROP TRIGGER IF EXISTS inherit_import_item_imported_as_fkey ON vandelay.import_item;
7 DROP TRIGGER IF EXISTS inherit_asset_copy_note_copy_fkey ON asset.copy_note;
8 DROP TRIGGER IF EXISTS inherit_asset_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;
10 CREATE CONSTRAINT TRIGGER inherit_copy_bucket_item_target_copy_fkey
11 AFTER UPDATE OR INSERT ON container.copy_bucket_item
12 DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.container_copy_bucket_item_target_copy_inh_fkey();
13 CREATE CONSTRAINT TRIGGER inherit_import_item_imported_as_fkey
14 AFTER UPDATE OR INSERT ON vandelay.import_item
15 DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.vandelay_import_item_imported_as_inh_fkey();
16 CREATE CONSTRAINT TRIGGER inherit_asset_copy_note_copy_fkey
17 AFTER UPDATE OR INSERT ON asset.copy_note
18 DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.asset_copy_note_owning_copy_inh_fkey();
19 CREATE CONSTRAINT TRIGGER inherit_asset_copy_tag_copy_map_copy_fkey
20 AFTER UPDATE OR INSERT ON asset.copy_tag_copy_map
21 DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.asset_copy_tag_copy_map_copy_inh_fkey();