Multiple versions of triggers in a database system

A computer program product for managing multiple versions of triggers in a database system, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to:

• receive a first command to create a first version of a trigger to apply a first set of actions in response to a triggering event, the triggering event comprising an input/output operation on a database object;
• based on the first command, create the first version of the trigger to apply the first set of actions in response to the triggering event, comprising:
• create the first version of the trigger to comprise the first set of actions;
• link the first version to the database object;
• and
• set the first version as a current version of the trigger;
• receive a second command to create a second version of the trigger to apply a second set of actions in response to the triggering event;
• based on the second command, create the second version of the trigger to apply the second set of actions in response to the second triggering event, without deleting the first version of the trigger, comprising:
• create the second version of the trigger to comprise the second set of actions;
• and
• link the second version to the database object;
• receive a third command to set the current version of the trigger to the second version;
• in response to receiving the third command, set the second version as the current version of the trigger;
• determine that the triggering event of the trigger occurs;
• in response to determining that the triggering event occurs, determine that the second version is the current version of the trigger;
• in response to determining that the second version is the current version of the trigger, retrieve the second set of actions comprised in the second version;
• and
• execute the second set of actions.

A system, comprising:

• a processor;
• and
• a computer readable storage medium having program instructions embodied therewith, the program instructions executable by the processor to cause the processor to:
• receive a first command to create a first version of a trigger to apply a first set of actions in response to a triggering event, the triggering event comprising an input/output operation on a database object;
• based on the first command, create the first version of the trigger to apply the first set of actions in response to the triggering event, comprising:
• create the first version of the trigger to comprise the first set of actions;
• link the first version to the database object;
• and
• set the first version as a current version of the trigger;
• receive a second command to create a second version of the trigger to apply a second set of actions in response to the triggering event;
• based on the second command, create the second version of the trigger to apply the second set of actions in response to the triggering event, without deleting the first version of the trigger, comprising:
• create the second version of the trigger to comprise the second set of actions;
• and
• link the second version to the database object;
• receive a third command to set the current version of the trigger to the second version;
• in response to receiving the third command, set the second version as the current version of the trigger;
• determine that the triggering event of the trigger occurs;
• in response to determining that the triggering event occurs, determine that the second version is the current version of the trigger;
• in response to determining that the second version is the current version of the trigger, retrieve the second set of actions comprised in the second version;
• and
• execute the second set of actions.