Y
Hacker News
new
|
ask
|
show
|
jobs
by
maiku2501
677 days ago
I haven't used row level security, but wouldn't it be easy to set the table up such that only a dedicated recovery role could select rows that have deleted_at set? Then the view wouldn't even be necessary.