Solutionunvalidated
with cte as (delete from edge where 'id1' in (id1,id2)) update node set version = version + 1 where id = 'id1'; — single query without having to start a transaction. Tension: should delete the edge; instead [23503] ERROR. Outcome: Or the other way around, taking `version` into account.
132da52d-6c2e-42d2-9441-9cff452f98dc
with cte as (delete from edge where 'id1' in (id1,id2)) update node set version = version + 1 where id = 'id1'; — single query without having to start a transaction. Tension: should delete the edge; instead [23503] ERROR. Outcome: Or the other way around, taking version into account.