Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| trig_b_d_syst_applications_delete_contexts() | FUNCTION | plpgsql | false | trigger | INVOKER | Deletes the Application Contexts prior to deleting the Application record itself. This is needed because the trigger preventing datastore context owner contexts to be deleted must be disabled prior to the delete. Trigger Function Details:
|
| trig_a_i_syst_instances_create_instance_contexts() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| trig_a_i_syst_instance_type_apps_create_inst_type_contexts() | FUNCTION | plpgsql | false | trigger | INVOKER | When a new association between an Application and an Instance Type is made by inserting a record into this table, Instance Type Contexts are automatically created by this function based on the Application Context records defined at the time of INSERT into this table. Trigger Function Details:
General Usage The default default_db_pool_size value is 0. After the fact changes to Contexts must be managed manually. |
| trig_b_iud_syst_application_contexts_validate_owner_context() | FUNCTION | plpgsql | false | trigger | INVOKER | Validates database_owner_context values based on the pre-existing state of the database. Trigger Function Details:
|
| trig_b_iu_syst_enum_items_validate_functional_types() | FUNCTION | plpgsql | false | trigger | INVOKER | Ensures that if the parent syst_enums record has syst_enum_functional_types records defined, a syst_enum_items record will reference one of those functional types. Trigger Function Details:
General Usage Note that this trigger function is intended to be use by constraint triggers. |
| trig_a_iu_syst_enum_items_maintain_sort_order() | FUNCTION | plpgsql | false | trigger | INVOKER | Automatically maintains the sort order of syst_enum_item records in cases where sort ordering collides with existing syst_enum_items records for the same enum_id. Trigger Function Details:
General Usage On insert or update when the new sort_order value matches that of an existing record for the enumeration, the system will sort the match record after the new/updated record. This will cascade for all syst_enum_items records matching the enum_id until the last one is updated. |
| trig_b_i_syst_enum_functional_type_validate_new_allowed() | FUNCTION | plpgsql | false | trigger | INVOKER | Checks to see if this is the first functional type being added for the enumeration and, if so, that no syst_enum_items records already exist. Trigger Function Details:
General Usage Adding a first functional type for an enumeration which already has defined enumeration items implies that the enumeration items must be assigned a functional type in the same operation to keep data consistency. In practice, this would be difficult since there would almost certainly have to be multiple functional types available in order to avoid making bogus assignments; it would be much more difficult to manage such a process as compared to simply disallowing the scenario. |
| trig_b_i_syst_enum_items_maintain_sort_order() | FUNCTION | plpgsql | false | trigger | INVOKER | For INSERTed records with a null sort_order value, this trigger will assign a default value assuming the new record should be inserted at the end of the sort. Trigger Function Details:
General Usage If the inserted record was already assigned a sort_order value, the inserted value is respected. |