Include logger_logs_apex_items in purge procedure
martindsouza opened this issue · 1 comments
martindsouza commented
From @shakerlxxv on October 20, 2013 2:50
Add the logger_logs_apex_items table to the purge() procedure to keep things cleaned up.
Copied from original issue: tmuth#54
martindsouza commented
This should already occur as part of the logger.purge
process. logger_logs_apex_items
has a foreign key to logger_logs
which uses the ON DELETE CASCADE
option. This means that each time the parent item in logger_logs
is deleted, the associated values in logger_logs_apex_items
is also deleted.
To confirm:
-- Look at the DELETE_RULE column
select *
from user_constraints
where constraint_name = 'LOGGER_LOGS_APX_ITMS_FK';