3 -- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 -- In some cases, asset.copy_tag_copy_map might have an inh_fkey()
6 -- trigger that fires on delete when it's not supposed to. This
7 -- update drops all inh_fkey triggers on that table and recreates
8 -- the known good version.
9 DROP TRIGGER IF EXISTS inherit_asset_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;
10 DROP TRIGGER IF EXISTS inherit_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;
12 CREATE CONSTRAINT TRIGGER inherit_asset_copy_tag_copy_map_copy_fkey
13 AFTER UPDATE OR INSERT ON asset.copy_tag_copy_map
14 DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.asset_copy_tag_copy_map_copy_inh_fkey();