Under what circumstances would the _DELETE trigger get called? (_EVW)

Question

Oracle 18c/10.7.1 geodatabase:
When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created:

V000001_DELETE
V000001_INSERT
V000001_UPDATE

When I look at the _DELETE trigger, I see that it belongs to the versioned view:
INSTEAD OF DELETE
ON MAXIMO.TEST_FC_EVW  --<<--- versioned view

If I delete a feature from the feature class while using the default version, the trigger does not get called.
Question:
Under what circumstances would the _DELETE trigger get called?

S_K · Answer

The delete trigger would get called when deletion of the feature is done from a child version.
The deleted row would be stored in the delta D table created upon registering the FC as versioned for the feature class.

Under what circumstances would the _DELETE trigger get called? (_EVW)

One Answer

Add your own answers!

Ask a Question