[PostgreSQL] trigger sample

create-trigger-sample.sql

-- psql -p 24001 -U hinemos -f create-trigger-sample.sql
CREATE OR REPLACE FUNCTION log_cc_cfg_facility_relation_delete() RETURNS TRIGGER AS $$
  BEGIN
  RAISE LOG 'DELETE cc_cfg_facility_relation: % %',
    OLD.parent_facility_id, OLD.child_facility_id;
  RETURN NULL;
  END
$$ LANGUAGE plpgsql;

CREATE TRIGGER trg_cc_cfg_facility_relation_delete
  AFTER DELETE ON setting.cc_cfg_facility_relation
  FOR EACH ROW
  EXECUTE PROCEDURE log_cc_cfg_facility_relation_delete();

drop-trigger-sample.sql

-- psql -p 24001 -U hinemos -f drop-trigger-sample.sql
DROP TRIGGER IF EXISTS trg_cc_cfg_facility_relation_delete
  ON setting.cc_cfg_facility_relation;
DROP FUNCTION IF EXISTS log_cc_cfg_facility_relation_delete();