SAP HANA DB question

[DanielleLarocca]

If we have a table trigger that becomes invalid by, for example, referencing a column that no longer exists, is there a way that we can still allow transactions on that table to succeed? So an insert or update operation should still complete on this table with an invalid trigger.

[Taesuk]

Hi Larocca,

The trigger is re-evaluated prior to the event and finds that the dependent object no longer exists and throws an "failure in revalidating check for trigger" error and exists the statement.

This is to protect the original context of the logic and if just drops without errors the column drop will go unnoticed. If you feel that this is an important feature, do you mind add this as a feature request in our customer influence site found at influence.sap.com

Best regards,

Tae-Suk

[瑞迪秋拉丝]

Hi, we met the same problem, have you solved this feature?

We just don't want the trigger error happen.