Historical backfills must break non-deferrable foreign-key cycles and honor write triggers
Historical backfills must account for non-deferrable foreign-key cycles and write triggers. Break an immediate cycle by inserting the first side with the cyclic reference unset, inserting the dependent row, and then patching the reference. Reconstruct rows through trigger-legal s…