3 CREATE OR REPLACE FUNCTION action.hold_request_clear_map () RETURNS TRIGGER AS $$
5 DELETE FROM action.hold_copy_map WHERE hold = NEW.id;
10 CREATE TRIGGER hold_request_clear_map_tgr
11 AFTER UPDATE ON action.hold_request
14 (NEW.cancel_time IS NOT NULL AND OLD.cancel_time IS NULL)
15 OR (NEW.fulfillment_time IS NOT NULL AND OLD.fulfillment_time IS NULL)
17 EXECUTE PROCEDURE action.hold_request_clear_map();