3 ms·
That doesn't solve the foreign key problem. You can still easily have a reference to a record that is "deleted"
by vlunkr 4y ago
That doesn't solve the foreign key problem. You can still easily have a reference to a record that is "deleted"
- yen223 4y agoAlso in Postgres, you cannot have a foreign key constraint that references a view, not even a materialised view. I'm with the author on this one. Any soft delete logic does have a tendency to bleed into other systems and make your systems more complicated, for very little gain.