create table temp_obj(
    id_operation numeric
);

CREATE OR REPLACE FUNCTION process_del_dept() RETURNS TRIGGER AS $new_dept$
    BEGIN
        if(TG_OP = 'DELETE') THEN
            DELETE from new_Emp where new_emp.deptno = OLD.deptno;
            insert into temp_obj(id_operation) values (OLD.deptno);
        END IF;
        RETURN NULL;
    END;
$new_dept$ LANGUAGE plpgsql;

create trigger del_dept
BEFORE DELETE ON new_dept
    FOR EACH ROW EXECUTE FUNCTION process_del_dept();

CREATE OR REPLACE FUNCTION process_del_dept_after() RETURNS TRIGGER AS $new_dept$
    BEGIN
        if(TG_OP = 'DELETE') THEN
            DELETE from new_Dept where new_dept.deptno = (select max(id_operation) from temp_obj);
            delete from temp_obj;
        END IF;
        RETURN NULL;
    END;
$new_dept$ LANGUAGE plpgsql;


create or replace trigger del_dept_after
after DELETE ON new_dept
    FOR EACH ROW EXECUTE FUNCTION process_del_dept_after();