Postgresql – Delete from child table on update of parent row with composite foreign key
For reasons outside of my control I am trying to build a graph-like data structure in PostgreSQL. The business requirement is that everytime a node changes, its edges need to be re-computed. Also, there is the possibility of stale reads…