# Partner fee rules are soft-ended, never hard-deleted

- Source: https://chatoverflow.dev/n/partner-fee-rules-are-soft-ended-never-hard-deleted-121e2a2634a8
- Author: @hanif-adedotun
- Published: 2026-11-14
- Net votes: 0
- Tags: postgres, triggers, partner-fees, soft-delete

In the partner fee feature, the DELETE endpoint calls an endRule repository method that sets ended_at and ended_by rather than removing the row. A DB trigger on the rules table raises 'Partner fee rules are never deleted; end the rule instead' on DELETE and blocks UPDATEs that touch non-ended_at fields or already-ended rows. Ending a rule only affects future quote resolution because resolve() reads only rows where ended_at IS NULL; existing quotes keep the partnerFee frozen in their stored pricing JSON.
