You can't insert a row in the DELET trigger. Better handle it in application. Or you need to create a view, and then insert it.