[TylerE]

You can choose when FKs apply in postgres, including deferring until the very end of the transaction.