Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
ft_vw_prank_weir_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_infiltration_installation_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
vw_file_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ws_symbology_update_by_reach()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_individual_surface_update()	FUNCTION	plpgsql	false	trigger	INVOKER
set_organisations_active(_undo_existing boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
ft_vw_channel_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_reach_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tank_cleaning_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_electromechanical_equipment_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_backflow_prevention_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_special_structure_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_access_aid_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_on_wastewater_structure_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_reservoir_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
check_all_nulls(rec record, prefix character varying, ignored_postfix text[] DEFAULT ARRAY['obj_id'::text, 'identifier'::text])	FUNCTION	plpgsql	false	boolean	INVOKER
ft_vw_wwtp_structure_update()	FUNCTION	plpgsql	false	trigger	INVOKER
check_modification_enabled()	FUNCTION	plpgsql	false	boolean	DEFINER
symbology_update_by_reach_point()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_infiltration_installation_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_overflow_update()	FUNCTION	plpgsql	false	trigger	INVOKER
synchronize_level_with_altitude_on_cover()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_dryweather_flume_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_solids_retention_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_bio_ecol_assessment_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_maintenance_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_reservoir_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_param_ca_mouse1_update()	FUNCTION	plpgsql	false	trigger	INVOKER
import_manhole_quarantine_delete_entry()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_wastewater_structure_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_electromechanical_equipment_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_flushing_nozzle_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_drainless_toilet_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_building_update()	FUNCTION	plpgsql	false	trigger	INVOKER
import_manhole_quarantine_try_structure_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tank_cleaning_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_small_treatment_plant_update()	FUNCTION	plpgsql	false	trigger	INVOKER
import_manhole_quarantine_try_let_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_cover_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_special_structure_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wastewater_structure_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wastewater_structure_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_leapingweir_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_cover_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_leapingweir_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_reach_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_unset_default_values()	FUNCTION	plpgsql	false	trigger	DEFINER
ft_vw_fountain_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_param_ca_mouse1_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_pump_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_fountain_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
update_wn_symbology_by_overflow(_obj_id text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
ft_vw_building_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_dryweather_downspout_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_benching_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_manhole_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_bio_ecol_assessment_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_additional_ws_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_leapingweir_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_maintenance_event_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_damage_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
get_default_values(field_name text)	FUNCTION	plpgsql	false	character varying	DEFINER
ft_vw_drainless_toilet_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_on_reach_change()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_flushing_nozzle_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tank_cleaning_update()	FUNCTION	plpgsql	false	trigger	INVOKER
alter_symbology_triggers(action_name text)	FUNCTION	plpgsql	false	void	DEFINER
symbology_on_structure_part_change_networkelement()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_reach_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_drainage_system_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wastewater_structure_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_reach_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_solids_retention_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_building_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_dryweather_downspout_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_prank_weir_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_backflow_prevention_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_reservoir_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_access_aid_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_manhole_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_maintenance_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_set_default_values()	FUNCTION	plpgsql	false	trigger	DEFINER
ft_vw_infiltration_zone_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_small_treatment_plant_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_damage_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_drainless_toilet_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_param_ca_general_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_electric_equipment_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_electric_equipment_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wastewater_node_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_dryweather_flume_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
network_refresh_network_simple()	FUNCTION	plpgsql	false	void	DEFINER
import_vw_manhole_insert_into_quarantine_or_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_measurement_series_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_dryweather_flume_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_discharge_point_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_small_treatment_plant_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_on_reach_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_individual_surface_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
update_wastewater_structure_label(_obj_id text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
ft_vw_backflow_prevention_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_reach_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_electromechanical_equipment_update()	FUNCTION	plpgsql	false	trigger	INVOKER
modification_last_modified()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_maintenance_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_channel_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_pump_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_on_cover_change()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tank_emptying_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
vw_file_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_param_ca_mouse1_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_discharge_point_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_bio_ecol_assessment_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_examination_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_on_wastewater_node_change()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_overflow_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_individual_surface_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
generate_oid(schema_name text, table_name text)	FUNCTION	plpgsql	false	text	INVOKER
ft_vw_solids_retention_update()	FUNCTION	plpgsql	false	trigger	INVOKER
wastewater_structure_update_fk_main_wastewater_node(_obj_id text DEFAULT NULL::text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
update_wastewater_node_symbology(_obj_id text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
ft_vw_cover_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_overflow_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_special_structure_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_benching_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_infiltration_installation_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_benching_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_infiltration_installation_update()	FUNCTION	plpgsql	false	trigger	INVOKER
vw_file_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
update_catchment_area_totals(_obj_id text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	DEFINER
ft_vw_tww_damage_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tank_emptying_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_dryweather_downspout_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_flushing_nozzle_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
synchronize_level_with_altitude_on_wastewater_node()	FUNCTION	plpgsql	false	trigger	INVOKER
update_depth(_obj_id text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
ft_vw_tww_additional_ws_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wastewater_node_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_measurement_series_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
modification_last_modified_parent()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wwtp_structure_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tank_emptying_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_examination_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_maintenance_event_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_examination_update()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_calculate_reach_length()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_wastewater_structure_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
alter_modification_triggers(action_name text)	FUNCTION	plpgsql	false	void	DEFINER
ft_vw_tww_infiltration_installation_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_channel_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_pump_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_fountain_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_param_ca_general_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_param_ca_general_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_prank_weir_update()	FUNCTION	plpgsql	false	trigger	INVOKER
wastewater_structure_update_fk_main_cover(_obj_id text DEFAULT NULL::text, _all boolean DEFAULT false)	FUNCTION	plpgsql	false	void	INVOKER
symbology_on_reach_point_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_discharge_point_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_infiltration_installation_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wastewater_node_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_additional_ws_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
symbology_update_by_channel()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_infiltration_zone_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_measurement_series_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_wwtp_structure_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_maintenance_event_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_drainage_system_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_electric_equipment_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_manhole_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_tww_wastewater_structure_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
reach_direction_change(reach_obj_ids text[])	FUNCTION	plpgsql	false	void	INVOKER
check_symbology_triggers_enabled()	FUNCTION	plpgsql	false	boolean	DEFINER
ft_vw_drainage_system_insert()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_access_aid_update()	FUNCTION	plpgsql	false	trigger	INVOKER
ft_vw_infiltration_zone_delete()	FUNCTION	plpgsql	false	trigger	INVOKER