Re:Soft deletion probably isn't worth it
by sa46 on Wednesday July 20, 2022 @01:00AM
(#32161604)
You lose traditional FK constraints with temporal tables since there's multiple copies of a row. One workaround is to partition current rows separately from historical rows and only enforce FK constraints on the current partition.
[ Parent
| on HN ]
There are no comments on this comment yet.