CREATE FUNCTION public.delete_index_task_after_delete_unit ()
	RETURNS trigger
	LANGUAGE plpgsql
	VOLATILE
	CALLED ON NULL INPUT
	SECURITY INVOKER
	COST 1
	AS $$
DECLARE
BEGIN
  DELETE FROM index_queue WHERE id_unit = OLD.id;
  RETURN NULL;
END;
$$;
CREATE TRIGGER delete_index_task_after_delete_unit_trigger
	AFTER DELETE
	ON public.unit
	FOR EACH ROW
	EXECUTE PROCEDURE public.delete_index_task_after_delete_unit();