maxg/omnivore

New keys do not delete stale computed values

Closed this issue · 0 comments

maxg commented

Adding a new key invokes the keys_apply_rules trigger and the keys_on_insert_delete_stale_computed rule.

If active is false but an active_rules row applies: keys_on_insert_delete_stale_computed does not match, then keys_apply_rules updates active to true, and the row is inserted (without applying keys_on_update_delete_stale_computed either).

Result: stale computed values that depend on the new key are not deleted.