Comment Comment by samanator Yes it can be done with rules, inheritance, triggers, and updatable views.See my answer on stack overflowhttps://stackoverflow.com/a/78694335/4188138However, in my experience, it's more easily maintainable to use normal deletes, have a trigger to move it to a schemaless table (jsonb column type that contains all of the data at the time of delete), and have manual restore logic via a good UX. parent samanator 2 years ago
See my answer on stack overflow
https://stackoverflow.com/a/78694335/4188138
However, in my experience, it's more easily maintainable to use normal deletes, have a trigger to move it to a schemaless table (jsonb column type that contains all of the data at the time of delete), and have manual restore logic via a good UX.