Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
sa46
on July 20, 2022
|
parent
|
context
|
favorite
| on:
Soft deletion probably isn't worth it
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.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: