Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| manage_object_timestamps() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| control_observation_editing_capability() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| trg_after_import_validation() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| trg_parse_indicator_paths() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| find_observation_with_wrong_spatial_object(_id_series integer) | FUNCTION | plpgsql | false | TABLE(ob_uid uuid, so_unique_id text) | INVOKER | Find the observations with having incompatible start and end timestamp with related spatial objects validity dates |
| log_deleted_object() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| update_observations_with_wrong_spatial_objects(_id_series integer) | FUNCTION | plpgsql | false | TABLE(modified_obs_count integer, remaining_obs_count integer) | INVOKER | Update observations with wrong spatial objects: it search the observation for which the start and end timestamp does not match anymore the related spatial objects validity dates. It gets the correct one if possible and perform an UPDATE for these observations. It returns a line with 2 integer columns: modified_obs_count (number of modified observations) and remaining_obs_count (number of observations still with wrong observations |
| parse_indicator_paths(i_id integer, i_path text) | FUNCTION | plpgsql | false | integer | INVOKER | |
| update_spatial_object_end_validity() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| update_observation_on_spatial_object_change() | FUNCTION | plpgsql | false | trigger | INVOKER |