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.