DELETE FROM A
WHERE A.b_id IN (select b_id from A where ..)

DELETE FROM B
WHERE B.id IN (select b_id from A where ..)

alter table A
   add constraint rel_permis foreign key (permission_id)
      references permission (permission_id)
      on delete restrict on update restrict;

alter table A
   add constraint rel_route_2_permission_route foreign key (route_id)
      references route (route_id)
      on delete restrict on update restrict;

alter table B
   add constraint rel_route_type_2_route foreign key (route_type_id)
      references route_type (route_type_id)
      on delete restrict on update restrict;

DELETE FROM B
WHERE id IN (select b_id from A where ..);


DELETE FROM A
WHERE b_id IN (select b_id from A where ..);

ОШИБКА:  UPDATE или DELETE в таблице "B" нарушает ограничение внешнего ключа "rel_route_2_permission_route" таблицы "A"
DETAIL:  На ключ (route_id)=(357) всё ещё есть ссылки в таблице "A".
********** Ошибка **********

ALTER TABLE A
  ADD CONSTRAINT rel_route_2_permission_route FOREIGN KEY (b_id)
      REFERENCES B (id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT;