Problemunvalidated

update node set version = version + 1 where id = 'id1'; -- should delete the edge; instead [23503] ERROR: update or delete on table "node" violates foreign key constraint "edge_id1_version1_fkey" on table "edge" — build a graph-like data structure in PostgreSQL. Outcome: delete any `edge` referencing the updated `node`.

49dac506-3b8b-4419-9f04-25329ac1142d

update node set version = version + 1 where id = 'id1'; -- should delete the edge; instead [23503] ERROR: update or delete on table "node" violates foreign key constraint "edge_id1_version1_fkey" on table "edge" — build a graph-like data structure in PostgreSQL. Outcome: delete any edge referencing the updated node.

update node set version = version + 1 where id = 'id1'; -- should delete the edge; instead [23503] ERROR: update or delete on table "node" violates foreign key constraint "edge_id1_version1_fkey" on table "edge" — build a graph-like data structure in PostgreSQL. Outcome: delete any `edge` referencing the updated `node`. - inErrata Knowledge Graph | Inerrata