Postgresql trigger deneme

DROP FUNCTION IF EXISTS uyumsoft.zz_bb_func_cad_m_id ();

CREATE OR REPLACE FUNCTION uyumsoft.zz_bb_func_cad_m_id ()
RETURNS TRIGGER
AS
$$
BEGIN

 IF (TG_OP = 'INSERT') THEN



   UPDATE find_co_entity SET isblack_list =1 WHERE co_entity_id IN (
    SELECT cari.co_entity_id FROM FINT_CAD_M cadm
       JOIN fint_cad_d cadd ON cadm.cad_m_id=cadd.cad_m_id
       JOIN fint_cad_card tnm ON cadd.cad_card_id=tnm.cad_card_id
       JOIN zz_bb_entitytaxno cari ON cari.tax_no=tnm.tax_no AND cari.co_id=cadm.co_id
       JOIN FIND_CO_CAD_STAT_M statm ON cadm.cad_stat_m_id=statm.cad_stat_m_id AND cadm.co_id=statm.co_id
   WHERE statm.isunpaid_cad=1 AND cadd.cad_draw=2 AND cadm.cad_m_id=NEW.CAD_M_ID );
 
   update FINT_CAD_BLACK_LIST SET  isblack_list =1 WHERE tax_identify_no IN (
    SELECT blacklist.tax_identify_no FROM FINT_CAD_M cadm
       JOIN fint_cad_d cadd ON cadm.cad_m_id=cadd.cad_m_id
       JOIN fint_cad_card tnm ON cadd.cad_card_id=tnm.cad_card_id
       JOIN FINT_CAD_BLACK_LIST blacklist ON blacklist.tax_identify_no=tnm.tax_no
       JOIN FIND_CO_CAD_STAT_M statm ON cadm.cad_stat_m_id=statm.cad_stat_m_id AND cadm.co_id=statm.co_id
    WHERE statm.isunpaid_cad=1 AND cadd.cad_draw=1 AND cadm.cad_m_id=NEW.CAD_M_ID );



 END IF;
 RETURN NEW;
END;
$$
LANGUAGE PLPGSQL;







CREATE CONSTRAINT TRIGGER zz_bb_trg_cad_d_id
  AFTER INSERT
  ON uyumsoft.FINT_CAD_D
  FROM uyumsoft.FINT_CAD_D NOT DEFERRABLE
FOR EACH ROW
  EXECUTE PROCEDURE uyumsoft.zz_bb_func_cad_m_id();