View Issue Details

IDProjectCategoryView StatusLast Update
0004050SymmetricDS ProImprovementpublic2022-09-06 17:46
Reporterhanes Assigned To 
Prioritynormal 
Status closedResolutionno change required 
Product Version3.10.3 
Summary0004050: Dropping a trigger from the Installed Triggers UI should probably NOT invalidate the trigger_hist but instead log a console evnt
DescriptionCurrently, when dropping a trigger via the Installed Trigger UIs, the triggers are dropped, and the table's trigger_hist entry is inactivated. This causes confusion if doing a Load, for example, in that the table will potentially show in the list of tables but no load event for the table will appear in the batches (due to that table not having an active trigger_hist row).

In addition, a console event should be logged for recordkeeping, showing that the user 'manually' dropped the triggers.
TagsNo tags attached.

Activities

elong

2019-07-22 13:14

developer   ~0001562

It's not as simple as just dropping the trigger and keeping the trigger hist. The Manage -> Installed Triggers panel is displaying the trigger histories. So if you change it to drop just the trigger, it continues to display the row from trigger hist like nothing happened. It does currently log a console event.

Issue History

Date Modified Username Field Change
2019-07-17 17:19 hanes New Issue
2019-07-17 17:19 hanes Status new => confirmed
2019-07-17 17:20 hanes Summary Dropping a trigger from the Installed Triggers UI should probably NOT invalidate the trigger_hist but instead log a console even => Dropping a trigger from the Installed Triggers UI should probably NOT invalidate the trigger_hist but instead log a console evnt
2019-07-17 17:20 hanes Description Updated View Revisions
2019-07-22 13:14 elong Note Added: 0001562
2019-07-23 15:59 hanes Description Updated View Revisions
2022-09-06 17:46 elong Status confirmed => closed
2022-09-06 17:46 elong Resolution open => no change required