Understanding Tricky Joins and Multi-Table Updates — Writing a proper SQL UPDATE query involving multiple tables in Postgres can be tricky and counterintuitive. Here’s a particularly tricky example and the concepts involved.
Deferrable SQL Constraints in Depth — Automatic constraint enforcement is a useful and powerful feature, but sometimes there are reasons to defer enforcement, as examined in depth here.