-- Trigger to delete depositor relations if depositor account is closed   
   CREATE OR REPLACE Function account_delete_bankTriggerFunction()
        RETURNS TRIGGER
        LANGUAGE plpgsql
        AS $$
            BEGIN
            DELETE
            FROM depositor
            WHERE depositor.account_number = OLD.account_number;
            
            RETURN OLD;
            
       END; $$;
       
   CREATE OR REPLACE TRIGGER account_delete_bankTrigger
        AFTER DELETE ON account
        FOR EACH ROW
        
   
   EXECUTE PROCEDURE account_delete_bankTriggerFunction();