4 ms·
> I assume that the cascading done on GitHub would be done on a FK constraint, but I'm not really sure how you'd do a "cascading soft delete" without making som
by 411111111111111 5y ago
> I assume that the cascading done on GitHub would be done on a FK constraint, but I'm not really sure how you'd do a "cascading soft delete" without making some kind of manual cascading logic?
Couldn't you just use an on delete trigger for this? I have no experience one the subject however
- nine_k 5y agoAn ON UPDATE trigger for the is_deleted column would do. Some databases also support INSTEAD OF triggers.
- vaishnavsm 5y agoDoesn't ON UPDATE only work for foreign keys? As far as I know, it's used to update the foreign key itself, and not values based on relationships.
- deleted 5y ago[deleted]