Open-ILS/src/sql/Pg/upgrade/0976.schema.fix_circ_history_copy_ref.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('0976', :eg_version);
   4
   5 ALTER TABLE action.usr_circ_history
   6     DROP CONSTRAINT IF EXISTS usr_circ_history_target_copy_fkey;
   7
   8 CREATE TRIGGER action_usr_circ_history_target_copy_trig
   9     AFTER INSERT OR UPDATE ON action.usr_circ_history
  10     FOR EACH ROW EXECUTE PROCEDURE evergreen.fake_fkey_tgr('target_copy');
  11
  12 COMMIT;
  13