Created
July 4, 2022 09:18
-
-
Save ponceta/7a053cd9212e12f23faeaadc228789bc to your computer and use it in GitHub Desktop.
QWAT 1.3.6 Fail
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
C:\Program Files\pgAdmin 4\v6\runtime\pg_restore.exe --host "monserveur.pully.ch" --port "5432" --username "postgres" --no-password --role "postgres" --dbname "qwat_1.3.6_demo" --jobs "1" --verbose "pathtomybackupfile\\qwat_v1.3.6_data_and_structure_sample.backup" | |
pg_restore: connecting to database for restore | |
pg_restore: creating SCHEMA "qwat_dr" | |
pg_restore: creating SCHEMA "qwat_od" | |
pg_restore: creating SCHEMA "qwat_sigip" | |
pg_restore: creating SCHEMA "qwat_sys" | |
pg_restore: creating SCHEMA "qwat_vl" | |
pg_restore: creating EXTENSION "hstore" | |
pg_restore: creating COMMENT "EXTENSION hstore" | |
pg_restore: creating EXTENSION "postgis" | |
pg_restore: creating COMMENT "EXTENSION postgis" | |
pg_restore: creating TYPE "qwat_od.element_type" | |
pg_restore: creating TYPE "qwat_od.installation_type" | |
pg_restore: creating TYPE "qwat_od.node_type" | |
pg_restore: creating TYPE "qwat_od.pipe_connection" | |
pg_restore: creating TYPE "qwat_sys.version_result" | |
pg_restore: creating FUNCTION "qwat_dr.ft_dimension_distance_distance()" | |
pg_restore: creating COMMENT "qwat_dr.FUNCTION ft_dimension_distance_distance()" | |
pg_restore: creating FUNCTION "qwat_od.fn_get_district(public.geometry)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_get_district(public.geometry)" | |
pg_restore: creating FUNCTION "qwat_od.fn_get_pressurezone(public.geometry)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_get_pressurezone(public.geometry)" | |
pg_restore: creating FUNCTION "qwat_od.fn_get_printmap_id(public.geometry)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_get_printmap_id(public.geometry)" | |
pg_restore: creating FUNCTION "qwat_od.fn_get_printmaps(public.geometry)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_get_printmaps(public.geometry)" | |
pg_restore: creating FUNCTION "qwat_od.fn_litres_per_cm(integer, double precision, double precision)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_litres_per_cm(fk_type integer, dim1 double precision, dim2 double precision)" | |
pg_restore: creating FUNCTION "qwat_od.fn_node_create(public.geometry, boolean)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_node_create(_point public.geometry, deactivate_node_add_pipe_vertex boolean)" | |
pg_restore: creating FUNCTION "qwat_od.fn_node_get_ids(public.box2d)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_node_get_ids(extent public.box2d)" | |
pg_restore: creating FUNCTION "qwat_od.fn_node_set_type(integer[])" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_node_set_type(_node_ids integer[])" | |
pg_restore: creating FUNCTION "qwat_od.fn_node_set_type(integer)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_node_set_type(_node_id integer)" | |
pg_restore: creating FUNCTION "qwat_od.fn_node_update_id()" | |
pg_restore: creating FUNCTION "qwat_od.fn_pipe_delete_valve(integer)" | |
pg_restore: creating FUNCTION "qwat_od.fn_pipe_get_id(public.geometry)" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION fn_pipe_get_id(_geometry public.geometry)" | |
pg_restore: creating FUNCTION "qwat_od.fn_pipe_update_valve(integer)" | |
pg_restore: creating FUNCTION "qwat_od.fn_update_pipe_crossing(boolean, boolean)" | |
pg_restore: creating FUNCTION "qwat_od.fn_update_sequences()" | |
pg_restore: creating FUNCTION "qwat_od.fn_valve_set_orientation(integer)" | |
pg_restore: creating FUNCTION "qwat_od.ft_before_valve()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_before_valve()" | |
pg_restore: creating FUNCTION "qwat_od.ft_controled_crossing()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_hydrant_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_hydrant_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_hydrant_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_installation_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_installation_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_installation_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_meter_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_meter_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_meter_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_part_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_part_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_part_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_samplingpoint_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_samplingpoint_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_samplingpoint_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_subscriber_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_subscriber_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_element_subscriber_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_geom3d_altitude()" | |
pg_restore: creating FUNCTION "qwat_od.ft_geometry_alternative_aux()" | |
pg_restore: creating FUNCTION "qwat_od.ft_geometry_alternative_main()" | |
pg_restore: creating FUNCTION "qwat_od.ft_leak_pipe()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_leak_pipe()" | |
pg_restore: creating FUNCTION "qwat_od.ft_leak_repaired()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_leak_repaired()" | |
pg_restore: creating FUNCTION "qwat_od.ft_node_element_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_node_element_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_node_element_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_node_geom()" | |
pg_restore: creating FUNCTION "qwat_od.ft_pipe_geom()" | |
pg_restore: creating FUNCTION "qwat_od.ft_pipe_node_moved()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_pipe_node_moved()" | |
pg_restore: creating FUNCTION "qwat_od.ft_pipe_node_type()" | |
pg_restore: creating FUNCTION "qwat_od.ft_pipe_schema_visible()" | |
pg_restore: creating FUNCTION "qwat_od.ft_pipe_tunnelbridge()" | |
pg_restore: creating FUNCTION "qwat_od.ft_tank()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_valve()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve_add_pipe_vertex()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve_geom()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_valve_geom()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve_handle_altitude()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_valve_handle_altitude()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve_main_altitude()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_valve_main_altitude()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve_pipe_update()" | |
pg_restore: creating COMMENT "qwat_od.FUNCTION ft_valve_pipe_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_valve_schema_visible()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_installation_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_installation_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_installation_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_network_element_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_network_element_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_network_element_update()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_node_delete()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_node_insert()" | |
pg_restore: creating FUNCTION "qwat_od.ft_vw_qwat_node_update()" | |
pg_restore: creating FUNCTION "qwat_sys._list_audit_tables()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION _list_audit_tables()" | |
pg_restore: creating FUNCTION "qwat_sys._list_audit_views()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION _list_audit_views()" | |
pg_restore: creating FUNCTION "qwat_sys.activate_audit_tables()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION activate_audit_tables()" | |
pg_restore: creating FUNCTION "qwat_sys.activate_audit_views()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION activate_audit_views()" | |
pg_restore: creating FUNCTION "qwat_sys.audit_table(regclass)" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION audit_table(target_table regclass)" | |
pg_restore: creating FUNCTION "qwat_sys.audit_table(regclass, boolean, boolean)" | |
pg_restore: creating FUNCTION "qwat_sys.audit_table(regclass, boolean, boolean, text[])" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION audit_table(target_table regclass, audit_rows boolean, audit_query_text boolean, ignored_cols text[])" | |
pg_restore: creating FUNCTION "qwat_sys.audit_view(regclass, boolean, text[], text[])" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION audit_view(target_view regclass, audit_query_text boolean, ignored_cols text[], uid_cols text[])" | |
pg_restore: creating FUNCTION "qwat_sys.deactivate_audit_tables()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION deactivate_audit_tables()" | |
pg_restore: creating FUNCTION "qwat_sys.deactivate_audit_views()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION deactivate_audit_views()" | |
pg_restore: creating FUNCTION "qwat_sys.fn_enable_schemavisible(text, text, text)" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION fn_enable_schemavisible(_table_name text, _vl_table text, _fk_field text)" | |
pg_restore: creating FUNCTION "qwat_sys.fn_label_create_fields(text, boolean, boolean)" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION fn_label_create_fields(_tbl text, _position boolean, _rotation boolean)" | |
pg_restore: creating FUNCTION "qwat_sys.fn_setting_srid()" | |
pg_restore: creating FUNCTION "qwat_sys.ft_setting_create_fn_get()" | |
pg_restore: creating FUNCTION "qwat_sys.if_modified_func()" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION if_modified_func()" | |
pg_restore: creating FUNCTION "qwat_sys.replay_event(integer)" | |
pg_restore: creating COMMENT "qwat_sys.FUNCTION replay_event(pevent_id integer)" | |
pg_restore: creating FUNCTION "qwat_sys.unaudit_table(regclass)" | |
pg_restore: creating FUNCTION "qwat_sys.unaudit_view(regclass)" | |
pg_restore: creating FUNCTION "qwat_vl.pipe_material_displayname()" | |
pg_restore: creating COMMENT "qwat_vl.FUNCTION pipe_material_displayname()" | |
pg_restore: creating TABLE "qwat_dr.annotationline" | |
pg_restore: creating COMMENT "qwat_dr.TABLE annotationline" | |
pg_restore: creating SEQUENCE "qwat_dr.annotationline_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_dr.annotationline_id_seq" | |
pg_restore: creating TABLE "qwat_dr.annotationpoint" | |
pg_restore: creating COMMENT "qwat_dr.TABLE annotationpoint" | |
pg_restore: creating SEQUENCE "qwat_dr.annotationpoint_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_dr.annotationpoint_id_seq" | |
pg_restore: creating TABLE "qwat_dr.constructionpoint" | |
pg_restore: creating COMMENT "qwat_dr.TABLE constructionpoint" | |
pg_restore: creating SEQUENCE "qwat_dr.constructionpoint_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_dr.constructionpoint_id_seq" | |
pg_restore: creating TABLE "qwat_dr.dimension_distance" | |
pg_restore: creating COMMENT "qwat_dr.TABLE dimension_distance" | |
pg_restore: creating SEQUENCE "qwat_dr.dimension_distance_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_dr.dimension_distance_id_seq" | |
pg_restore: creating TABLE "qwat_dr.dimension_orientation" | |
pg_restore: creating COMMENT "qwat_dr.TABLE dimension_orientation" | |
pg_restore: creating SEQUENCE "qwat_dr.dimension_orientation_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_dr.dimension_orientation_id_seq" | |
pg_restore: creating TABLE "qwat_od.chamber" | |
pg_restore: creating COMMENT "qwat_od.COLUMN chamber.flow_meter" | |
pg_restore: creating COMMENT "qwat_od.COLUMN chamber.water_meter" | |
pg_restore: creating COMMENT "qwat_od.COLUMN chamber.manometer" | |
pg_restore: creating TABLE "qwat_od.consumptionzone" | |
pg_restore: creating COMMENT "qwat_od.TABLE consumptionzone" | |
pg_restore: creating SEQUENCE "qwat_od.consumptionzone_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.consumptionzone_id_seq" | |
pg_restore: creating TABLE "qwat_od.cover" | |
pg_restore: creating COMMENT "qwat_od.TABLE cover" | |
pg_restore: creating COMMENT "qwat_od.COLUMN cover.form_dimension" | |
pg_restore: creating SEQUENCE "qwat_od.cover_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.cover_id_seq" | |
pg_restore: creating TABLE "qwat_od.crossing" | |
pg_restore: creating SEQUENCE "qwat_od.crossing_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.crossing_id_seq" | |
pg_restore: creating TABLE "qwat_od.damage" | |
pg_restore: creating COMMENT "qwat_od.TABLE damage" | |
pg_restore: creating SEQUENCE "qwat_od.damage_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.damage_id_seq" | |
pg_restore: creating TABLE "qwat_od.distributor" | |
pg_restore: creating COMMENT "qwat_od.TABLE distributor" | |
pg_restore: creating SEQUENCE "qwat_od.distributor_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.distributor_id_seq" | |
pg_restore: creating TABLE "qwat_od.district" | |
pg_restore: creating COMMENT "qwat_od.TABLE district" | |
pg_restore: creating SEQUENCE "qwat_od.district_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.district_id_seq" | |
pg_restore: creating TABLE "qwat_od.folder" | |
pg_restore: creating COMMENT "qwat_od.TABLE folder" | |
pg_restore: creating SEQUENCE "qwat_od.folder_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.folder_id_seq" | |
pg_restore: creating TABLE "qwat_od.hydrant" | |
pg_restore: creating COMMENT "qwat_od.TABLE hydrant" | |
pg_restore: creating COMMENT "qwat_od.COLUMN hydrant.fk_model_sup" | |
pg_restore: creating COMMENT "qwat_od.COLUMN hydrant.fk_model_inf" | |
pg_restore: creating COMMENT "qwat_od.COLUMN hydrant.marked" | |
pg_restore: creating COMMENT "qwat_od.COLUMN hydrant.pressure_static" | |
pg_restore: creating COMMENT "qwat_od.COLUMN hydrant.pressure_dynamic" | |
pg_restore: creating COMMENT "qwat_od.COLUMN hydrant.flow" | |
pg_restore: creating COMMENT "qwat_od.CONSTRAINT above_ground_hydrant_has_2_parts_check ON hydrant" | |
pg_restore: creating TABLE "qwat_od.installation" | |
pg_restore: creating COMMENT "qwat_od.TABLE installation" | |
pg_restore: creating TABLE "qwat_od.leak" | |
pg_restore: creating COMMENT "qwat_od.TABLE leak" | |
pg_restore: creating SEQUENCE "qwat_od.leak_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.leak_id_seq" | |
pg_restore: creating TABLE "qwat_od.meter" | |
pg_restore: creating COMMENT "qwat_od.TABLE meter" | |
pg_restore: creating TABLE "qwat_od.meter_reference" | |
pg_restore: creating COMMENT "qwat_od.TABLE meter_reference" | |
pg_restore: creating SEQUENCE "qwat_od.meter_reference_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.meter_reference_id_seq" | |
pg_restore: creating TABLE "qwat_od.network_element" | |
pg_restore: creating COMMENT "qwat_od.TABLE network_element" | |
pg_restore: creating COMMENT "qwat_od.COLUMN network_element.orientation" | |
pg_restore: creating TABLE "qwat_od.node" | |
pg_restore: creating COMMENT "qwat_od.TABLE node" | |
pg_restore: creating SEQUENCE "qwat_od.node_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.node_id_seq" | |
pg_restore: creating TABLE "qwat_od.part" | |
pg_restore: creating COMMENT "qwat_od.TABLE part" | |
pg_restore: creating TABLE "qwat_od.pipe" | |
pg_restore: creating COMMENT "qwat_od.TABLE pipe" | |
pg_restore: creating COMMENT "qwat_od.COLUMN pipe.year" | |
pg_restore: creating COMMENT "qwat_od.COLUMN pipe.year_rehabilitation" | |
pg_restore: creating COMMENT "qwat_od.COLUMN pipe.year_end" | |
pg_restore: creating COMMENT "qwat_od.COLUMN pipe._schema_visible" | |
pg_restore: creating COMMENT "qwat_od.CONSTRAINT pipe_year_check ON pipe" | |
pg_restore: creating COMMENT "qwat_od.CONSTRAINT pipe_year_end_check ON pipe" | |
pg_restore: creating COMMENT "qwat_od.CONSTRAINT pipe_year_rehabilitation_check ON pipe" | |
pg_restore: creating SEQUENCE "qwat_od.pipe_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.pipe_id_seq" | |
pg_restore: creating TABLE "qwat_od.pressurecontrol" | |
pg_restore: creating TABLE "qwat_od.pressurezone" | |
pg_restore: creating COMMENT "qwat_od.TABLE pressurezone" | |
pg_restore: creating SEQUENCE "qwat_od.pressurezone_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.pressurezone_id_seq" | |
pg_restore: creating TABLE "qwat_od.printmap" | |
pg_restore: creating COMMENT "qwat_od.TABLE printmap" | |
pg_restore: creating SEQUENCE "qwat_od.printmap_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.printmap_id_seq" | |
pg_restore: creating TABLE "qwat_od.protectionzone" | |
pg_restore: creating COMMENT "qwat_od.TABLE protectionzone" | |
pg_restore: creating SEQUENCE "qwat_od.protectionzone_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.protectionzone_id_seq" | |
pg_restore: creating TABLE "qwat_od.pump" | |
pg_restore: creating TABLE "qwat_od.remote" | |
pg_restore: creating COMMENT "qwat_od.TABLE remote" | |
pg_restore: creating SEQUENCE "qwat_od.remote_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.remote_id_seq" | |
pg_restore: creating TABLE "qwat_od.samplingpoint" | |
pg_restore: creating COMMENT "qwat_od.TABLE samplingpoint" | |
pg_restore: creating TABLE "qwat_od.source" | |
pg_restore: creating TABLE "qwat_od.subscriber" | |
pg_restore: creating COMMENT "qwat_od.TABLE subscriber" | |
pg_restore: creating TABLE "qwat_od.subscriber_reference" | |
pg_restore: creating COMMENT "qwat_od.TABLE subscriber_reference" | |
pg_restore: creating SEQUENCE "qwat_od.subscriber_reference_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.subscriber_reference_id_seq" | |
pg_restore: creating SEQUENCE "qwat_od.surveypoint_id_seq" | |
pg_restore: creating TABLE "qwat_od.surveypoint" | |
pg_restore: creating TABLE "qwat_od.tank" | |
pg_restore: creating COMMENT "qwat_od.COLUMN tank.storage_total" | |
pg_restore: creating COMMENT "qwat_od.COLUMN tank.storage_supply" | |
pg_restore: creating COMMENT "qwat_od.COLUMN tank.storage_fire" | |
pg_restore: creating TABLE "qwat_od.treatment" | |
pg_restore: creating TABLE "qwat_od.valve" | |
pg_restore: creating COMMENT "qwat_od.TABLE valve" | |
pg_restore: creating COMMENT "qwat_od.COLUMN valve._schema_visible" | |
pg_restore: creating SEQUENCE "qwat_od.valve_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.valve_id_seq" | |
pg_restore: creating VIEW "qwat_od.vw_consumptionzone" | |
pg_restore: creating VIEW "qwat_od.vw_node_element" | |
pg_restore: creating VIEW "qwat_od.vw_element_hydrant" | |
pg_restore: creating VIEW "qwat_od.vw_qwat_installation" | |
pg_restore: creating VIEW "qwat_od.vw_element_installation" | |
pg_restore: creating VIEW "qwat_od.vw_element_meter" | |
pg_restore: creating VIEW "qwat_od.vw_element_part" | |
pg_restore: creating VIEW "qwat_od.vw_element_samplingpoint" | |
pg_restore: creating VIEW "qwat_od.vw_element_subscriber" | |
pg_restore: creating TABLE "qwat_vl.value_list_base" | |
pg_restore: creating COMMENT "qwat_vl.TABLE value_list_base" | |
pg_restore: creating TABLE "qwat_vl.hydrant_material" | |
pg_restore: creating COMMENT "qwat_vl.COLUMN hydrant_material.pressure_nominal" | |
pg_restore: creating TABLE "qwat_vl.hydrant_model_inf" | |
pg_restore: creating TABLE "qwat_vl.hydrant_model_sup" | |
pg_restore: creating COMMENT "qwat_vl.TABLE hydrant_model_sup" | |
pg_restore: creating TABLE "qwat_vl.hydrant_output" | |
pg_restore: creating TABLE "qwat_vl.hydrant_provider" | |
pg_restore: creating COMMENT "qwat_vl.TABLE hydrant_provider" | |
pg_restore: creating TABLE "qwat_vl.object_reference" | |
pg_restore: creating COMMENT "qwat_vl.TABLE object_reference" | |
pg_restore: creating TABLE "qwat_vl.precision" | |
pg_restore: creating COMMENT "qwat_vl.TABLE "precision"" | |
pg_restore: creating TABLE "qwat_vl.precisionalti" | |
pg_restore: creating COMMENT "qwat_vl.TABLE precisionalti" | |
pg_restore: creating TABLE "qwat_vl.status" | |
pg_restore: creating COMMENT "qwat_vl.TABLE status" | |
pg_restore: creating VIEW "qwat_od.vw_export_hydrant" | |
pg_restore: creating TABLE "qwat_vl.cistern" | |
pg_restore: creating TABLE "qwat_vl.overflow" | |
pg_restore: creating TABLE "qwat_vl.pressurecontrol_type" | |
pg_restore: creating TABLE "qwat_vl.pump_operating" | |
pg_restore: creating TABLE "qwat_vl.pump_type" | |
pg_restore: creating TABLE "qwat_vl.remote_type" | |
pg_restore: creating TABLE "qwat_vl.source_quality" | |
pg_restore: creating TABLE "qwat_vl.source_type" | |
pg_restore: creating TABLE "qwat_vl.tank_firestorage" | |
pg_restore: creating TABLE "qwat_vl.watertype" | |
pg_restore: creating COMMENT "qwat_vl.TABLE watertype" | |
pg_restore: creating VIEW "qwat_od.vw_export_installation" | |
pg_restore: creating TABLE "qwat_vl.pipe_function" | |
pg_restore: creating COMMENT "qwat_vl.TABLE pipe_function" | |
pg_restore: creating TABLE "qwat_vl.pipe_installmethod" | |
pg_restore: creating COMMENT "qwat_vl.TABLE pipe_installmethod" | |
pg_restore: creating TABLE "qwat_vl.pipe_material" | |
pg_restore: creating COMMENT "qwat_vl.TABLE pipe_material" | |
pg_restore: creating COMMENT "qwat_vl.COLUMN pipe_material.diameter" | |
pg_restore: creating COMMENT "qwat_vl.COLUMN pipe_material.diameter_nominal" | |
pg_restore: creating COMMENT "qwat_vl.COLUMN pipe_material.diameter_external" | |
pg_restore: creating COMMENT "qwat_vl.COLUMN pipe_material.pressure_nominal" | |
pg_restore: creating COMMENT "qwat_vl.COLUMN pipe_material.sn" | |
pg_restore: creating TABLE "qwat_vl.pipe_protection" | |
pg_restore: creating COMMENT "qwat_vl.TABLE pipe_protection" | |
pg_restore: creating VIEW "qwat_od.vw_export_pipe" | |
pg_restore: creating TABLE "qwat_vl.leak_cause" | |
pg_restore: creating COMMENT "qwat_vl.TABLE leak_cause" | |
pg_restore: creating VIEW "qwat_od.vw_export_leak" | |
pg_restore: creating VIEW "qwat_od.vw_export_meter" | |
pg_restore: creating TABLE "qwat_vl.part_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE part_type" | |
pg_restore: creating VIEW "qwat_od.vw_export_part" | |
pg_restore: creating VIEW "qwat_od.vw_export_printmap" | |
pg_restore: creating VIEW "qwat_od.vw_export_remote" | |
pg_restore: creating TABLE "qwat_vl.subscriber_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE subscriber_type" | |
pg_restore: creating VIEW "qwat_od.vw_export_subscriber" | |
pg_restore: creating TABLE "qwat_vl.valve_actuation" | |
pg_restore: creating COMMENT "qwat_vl.TABLE valve_actuation" | |
pg_restore: creating TABLE "qwat_vl.valve_function" | |
pg_restore: creating COMMENT "qwat_vl.TABLE valve_function" | |
pg_restore: creating TABLE "qwat_vl.valve_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE valve_type" | |
pg_restore: creating VIEW "qwat_od.vw_export_valve" | |
pg_restore: creating VIEW "qwat_od.vw_pipe_child_parent" | |
pg_restore: while PROCESSING TOC: | |
pg_restore: from TOC entry 345; 1259 53664 VIEW vw_pipe_child_parent postgres | |
pg_restore: error: could not execute query: ERREUR: la fonction public.st_curvetoline(public.geometry, double precision) n'existe pas | |
LINE 4: (public.st_curvetoline(public.st_geomfromewkt(((((((((((... | |
^ | |
HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments. | |
Vous devez ajouter des conversions explicites de type. | |
Command was: CREATE VIEW qwat_od.vw_pipe_child_parent AS | |
SELECT foo2.child, | |
foo2.parent, | |
(public.st_curvetoline(public.st_geomfromewkt((((((((((((((('SRID='::text || qwat_sys.fn_setting_srid()) || ';CIRCULARSTRING('::text) || public.st_x(foo2.start_point)) || ' '::text) || public.st_y(foo2.start_point)) || ','::text) || (public.st_x(foo2.middle_point) + (foo2.distance * cos(foo2.azimuth)))) || ' '::text) || (public.st_y(foo2.middle_point) + (foo2.distance * sin(foo2.azimuth)))) || ','::text) || public.st_x(foo2.end_point)) || ' '::text) || public.st_y(foo2.end_point)) || ')'::text)), (15)::double precision))::public.geometry(LineString,21781) AS geometry | |
FROM ( SELECT foo.child, | |
foo.parent, | |
foo.start_point, | |
foo.end_point, | |
((pi() / (2)::double precision) + public.st_azimuth(foo.start_point, foo.end_point)) AS azimuth, | |
((0.5)::double precision * public.st_distance(foo.start_point, foo.end_point)) AS distance, | |
(public.st_lineinterpolatepoint(public.st_makeline(foo.start_point, foo.end_point), (0.5)::double precision))::public.geometry(Point,21781) AS middle_point | |
FROM ( SELECT a.id AS child, | |
b.id AS parent, | |
(public.st_force2d(public.st_lineinterpolatepoint(a.geometry, (0.5)::double precision)))::public.geometry(Point,21781) AS start_point, | |
public.st_closestpoint(public.st_makeline((public.st_lineinterpolatepoint(public.st_force2d(b.geometry), (LEAST((1)::numeric, (((4)::numeric / b._length2d) / (2)::numeric)))::double precision))::public.geometry(Point,21781), (public.st_lineinterpolatepoint(public.st_force2d(b.geometry), (GREATEST((0)::numeric, ((1)::numeric - (((4)::numeric / b._length2d) / (2)::numeric))))::double precision))::public.geometry(Point,21781)), a.geometry) AS end_point | |
FROM (qwat_od.pipe a | |
JOIN qwat_od.pipe b ON ((a.fk_parent = b.id))) | |
WHERE (a.fk_parent IS NOT NULL)) foo) foo2; | |
pg_restore: error: could not execute query: ERREUR: la relation « qwat_od.vw_pipe_child_parent » n'existe pas | |
Command was: ALTER TABLE qwat_od.vw_pipe_child_parent OWNER TO postgres; | |
pg_restore: creating VIEW "qwat_od.vw_pipe_schema_visibleitems" | |
pg_restore: creating COMMENT "qwat_od.VIEW vw_pipe_schema_visibleitems" | |
pg_restore: creating VIEW "qwat_od.vw_pipe_schema_merged" | |
pg_restore: creating VIEW "qwat_od.vw_pipe_schema" | |
pg_restore: creating COMMENT "qwat_od.VIEW vw_pipe_schema" | |
pg_restore: creating VIEW "qwat_od.vw_pipe_schema_error" | |
pg_restore: creating COMMENT "qwat_od.VIEW vw_pipe_schema_error" | |
pg_restore: creating TABLE "qwat_vl.protectionzone_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE protectionzone_type" | |
pg_restore: creating VIEW "qwat_od.vw_protectionzone" | |
pg_restore: creating VIEW "qwat_od.vw_qwat_network_element" | |
pg_restore: creating VIEW "qwat_od.vw_qwat_node" | |
pg_restore: creating VIEW "qwat_od.vw_subscriber_pipe_relation" | |
pg_restore: creating VIEW "qwat_od.vw_valve_lines" | |
pg_restore: creating COMMENT "qwat_od.VIEW vw_valve_lines" | |
pg_restore: creating TABLE "qwat_od.worker" | |
pg_restore: creating COMMENT "qwat_od.TABLE worker" | |
pg_restore: creating SEQUENCE "qwat_od.worker_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_od.worker_id_seq" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_damage" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_hydrant" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_installation" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_leak" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_part" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_pipe" | |
pg_restore: creating VIEW "qwat_sigip.vw_export_valve" | |
pg_restore: creating TABLE "qwat_sys.info" | |
pg_restore: creating SEQUENCE "qwat_sys.info_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_sys.info_id_seq" | |
pg_restore: creating TABLE "qwat_sys.logged_actions" | |
pg_restore: creating COMMENT "qwat_sys.TABLE logged_actions" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.event_id" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.schema_name" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.table_name" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.relid" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.session_user_name" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.action_tstamp_tx" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.action_tstamp_stm" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.action_tstamp_clk" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.transaction_id" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.application_name" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.client_addr" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.client_port" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.client_query" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.action" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.row_data" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.changed_fields" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_actions.statement_only" | |
pg_restore: creating SEQUENCE "qwat_sys.logged_actions_event_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_sys.logged_actions_event_id_seq" | |
pg_restore: creating TABLE "qwat_sys.logged_relations" | |
pg_restore: creating COMMENT "qwat_sys.TABLE logged_relations" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_relations.relation_name" | |
pg_restore: creating COMMENT "qwat_sys.COLUMN logged_relations.uid_column" | |
pg_restore: creating TABLE "qwat_sys.settings" | |
pg_restore: creating SEQUENCE "qwat_sys.settings_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_sys.settings_id_seq" | |
pg_restore: creating TABLE "qwat_sys.upgrades" | |
pg_restore: creating SEQUENCE "qwat_sys.upgrades_id_seq" | |
pg_restore: creating SEQUENCE OWNED BY "qwat_sys.upgrades_id_seq" | |
pg_restore: creating TABLE "qwat_vl.bedding" | |
pg_restore: creating COMMENT "qwat_vl.TABLE bedding" | |
pg_restore: creating TABLE "qwat_vl.cover_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE cover_type" | |
pg_restore: creating TABLE "qwat_vl.locationtype" | |
pg_restore: creating COMMENT "qwat_vl.TABLE locationtype" | |
pg_restore: creating TABLE "qwat_vl.nominal_diameter" | |
pg_restore: creating TABLE "qwat_vl.survey_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE survey_type" | |
pg_restore: creating TABLE "qwat_vl.valve_maintenance" | |
pg_restore: creating COMMENT "qwat_vl.TABLE valve_maintenance" | |
pg_restore: creating TABLE "qwat_vl.visible" | |
pg_restore: creating COMMENT "qwat_vl.TABLE visible" | |
pg_restore: creating TABLE "qwat_vl.worker_type" | |
pg_restore: creating COMMENT "qwat_vl.TABLE worker_type" | |
pg_restore: creating DEFAULT "qwat_dr.annotationline id" | |
pg_restore: creating DEFAULT "qwat_dr.annotationpoint id" | |
pg_restore: creating DEFAULT "qwat_dr.constructionpoint id" | |
pg_restore: creating DEFAULT "qwat_dr.dimension_distance id" | |
pg_restore: creating DEFAULT "qwat_dr.dimension_orientation id" | |
pg_restore: creating DEFAULT "qwat_od.consumptionzone id" | |
pg_restore: creating DEFAULT "qwat_od.cover id" | |
pg_restore: creating DEFAULT "qwat_od.crossing id" | |
pg_restore: creating DEFAULT "qwat_od.damage id" | |
pg_restore: creating DEFAULT "qwat_od.distributor id" | |
pg_restore: creating DEFAULT "qwat_od.district id" | |
pg_restore: creating DEFAULT "qwat_od.folder id" | |
pg_restore: creating DEFAULT "qwat_od.leak id" | |
pg_restore: creating DEFAULT "qwat_od.meter_reference id" | |
pg_restore: creating DEFAULT "qwat_od.node id" | |
pg_restore: creating DEFAULT "qwat_od.pipe id" | |
pg_restore: creating DEFAULT "qwat_od.pressurezone id" | |
pg_restore: creating DEFAULT "qwat_od.printmap id" | |
pg_restore: creating DEFAULT "qwat_od.protectionzone id" | |
pg_restore: creating DEFAULT "qwat_od.remote id" | |
pg_restore: creating DEFAULT "qwat_od.subscriber_reference id" | |
pg_restore: creating DEFAULT "qwat_od.valve id" | |
pg_restore: creating DEFAULT "qwat_od.worker id" | |
pg_restore: creating DEFAULT "qwat_sys.info id" | |
pg_restore: creating DEFAULT "qwat_sys.logged_actions event_id" | |
pg_restore: creating DEFAULT "qwat_sys.settings id" | |
pg_restore: creating DEFAULT "qwat_sys.upgrades id" | |
pg_restore: creating DEFAULT "qwat_vl.bedding vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.cistern vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.cover_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.hydrant_material vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.hydrant_model_inf vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.hydrant_model_sup vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.hydrant_output vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.hydrant_provider vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.leak_cause vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.locationtype vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.nominal_diameter vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.object_reference vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.overflow vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.part_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pipe_function vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pipe_installmethod vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pipe_material vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pipe_protection vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.precision vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.precisionalti vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pressurecontrol_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.protectionzone_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pump_operating vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.pump_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.remote_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.source_quality vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.source_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.status vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.subscriber_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.survey_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.tank_firestorage vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.valve_actuation vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.valve_function vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.valve_maintenance vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.valve_type vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.visible vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.watertype vl_active" | |
pg_restore: creating DEFAULT "qwat_vl.worker_type vl_active" | |
pg_restore: processing data for table "qwat_dr.annotationline" | |
pg_restore: processing data for table "qwat_dr.annotationpoint" | |
pg_restore: processing data for table "qwat_dr.constructionpoint" | |
pg_restore: processing data for table "qwat_dr.dimension_distance" | |
pg_restore: processing data for table "qwat_dr.dimension_orientation" | |
pg_restore: processing data for table "qwat_od.chamber" | |
pg_restore: processing data for table "qwat_od.consumptionzone" | |
pg_restore: processing data for table "qwat_od.cover" | |
pg_restore: processing data for table "qwat_od.crossing" | |
pg_restore: processing data for table "qwat_od.damage" | |
pg_restore: processing data for table "qwat_od.distributor" | |
pg_restore: processing data for table "qwat_od.district" | |
pg_restore: processing data for table "qwat_od.folder" | |
pg_restore: processing data for table "qwat_od.hydrant" | |
pg_restore: processing data for table "qwat_od.installation" | |
pg_restore: processing data for table "qwat_od.leak" | |
pg_restore: processing data for table "qwat_od.meter" | |
pg_restore: processing data for table "qwat_od.meter_reference" | |
pg_restore: processing data for table "qwat_od.network_element" | |
pg_restore: processing data for table "qwat_od.node" | |
pg_restore: processing data for table "qwat_od.part" | |
pg_restore: processing data for table "qwat_od.pipe" | |
pg_restore: processing data for table "qwat_od.pressurecontrol" | |
pg_restore: processing data for table "qwat_od.pressurezone" | |
pg_restore: processing data for table "qwat_od.printmap" | |
pg_restore: processing data for table "qwat_od.protectionzone" | |
pg_restore: processing data for table "qwat_od.pump" | |
pg_restore: processing data for table "qwat_od.remote" | |
pg_restore: processing data for table "qwat_od.samplingpoint" | |
pg_restore: processing data for table "qwat_od.source" | |
pg_restore: processing data for table "qwat_od.subscriber" | |
pg_restore: processing data for table "qwat_od.subscriber_reference" | |
pg_restore: processing data for table "qwat_od.surveypoint" | |
pg_restore: processing data for table "qwat_od.tank" | |
pg_restore: processing data for table "qwat_od.treatment" | |
pg_restore: processing data for table "qwat_od.valve" | |
pg_restore: processing data for table "qwat_od.worker" | |
pg_restore: processing data for table "qwat_sys.info" | |
pg_restore: processing data for table "qwat_sys.logged_actions" | |
pg_restore: processing data for table "qwat_sys.logged_relations" | |
pg_restore: processing data for table "qwat_sys.settings" | |
pg_restore: processing data for table "qwat_sys.upgrades" | |
pg_restore: processing data for table "qwat_vl.bedding" | |
pg_restore: processing data for table "qwat_vl.cistern" | |
pg_restore: processing data for table "qwat_vl.cover_type" | |
pg_restore: processing data for table "qwat_vl.hydrant_material" | |
pg_restore: processing data for table "qwat_vl.hydrant_model_inf" | |
pg_restore: processing data for table "qwat_vl.hydrant_model_sup" | |
pg_restore: processing data for table "qwat_vl.hydrant_output" | |
pg_restore: processing data for table "qwat_vl.hydrant_provider" | |
pg_restore: processing data for table "qwat_vl.leak_cause" | |
pg_restore: processing data for table "qwat_vl.locationtype" | |
pg_restore: processing data for table "qwat_vl.nominal_diameter" | |
pg_restore: processing data for table "qwat_vl.object_reference" | |
pg_restore: processing data for table "qwat_vl.overflow" | |
pg_restore: processing data for table "qwat_vl.part_type" | |
pg_restore: processing data for table "qwat_vl.pipe_function" | |
pg_restore: processing data for table "qwat_vl.pipe_installmethod" | |
pg_restore: processing data for table "qwat_vl.pipe_material" | |
pg_restore: processing data for table "qwat_vl.pipe_protection" | |
pg_restore: processing data for table "qwat_vl.precision" | |
pg_restore: processing data for table "qwat_vl.precisionalti" | |
pg_restore: processing data for table "qwat_vl.pressurecontrol_type" | |
pg_restore: processing data for table "qwat_vl.protectionzone_type" | |
pg_restore: processing data for table "qwat_vl.pump_operating" | |
pg_restore: processing data for table "qwat_vl.pump_type" | |
pg_restore: processing data for table "qwat_vl.remote_type" | |
pg_restore: processing data for table "qwat_vl.source_quality" | |
pg_restore: processing data for table "qwat_vl.source_type" | |
pg_restore: processing data for table "qwat_vl.status" | |
pg_restore: processing data for table "qwat_vl.subscriber_type" | |
pg_restore: processing data for table "qwat_vl.survey_type" | |
pg_restore: processing data for table "qwat_vl.tank_firestorage" | |
pg_restore: processing data for table "qwat_vl.value_list_base" | |
pg_restore: processing data for table "qwat_vl.valve_actuation" | |
pg_restore: processing data for table "qwat_vl.valve_function" | |
pg_restore: processing data for table "qwat_vl.valve_maintenance" | |
pg_restore: processing data for table "qwat_vl.valve_type" | |
pg_restore: processing data for table "qwat_vl.visible" | |
pg_restore: processing data for table "qwat_vl.watertype" | |
pg_restore: processing data for table "qwat_vl.worker_type" | |
pg_restore: executing SEQUENCE SET annotationline_id_seq | |
pg_restore: executing SEQUENCE SET annotationpoint_id_seq | |
pg_restore: executing SEQUENCE SET constructionpoint_id_seq | |
pg_restore: executing SEQUENCE SET dimension_distance_id_seq | |
pg_restore: executing SEQUENCE SET dimension_orientation_id_seq | |
pg_restore: executing SEQUENCE SET consumptionzone_id_seq | |
pg_restore: executing SEQUENCE SET cover_id_seq | |
pg_restore: executing SEQUENCE SET crossing_id_seq | |
pg_restore: executing SEQUENCE SET damage_id_seq | |
pg_restore: executing SEQUENCE SET distributor_id_seq | |
pg_restore: executing SEQUENCE SET district_id_seq | |
pg_restore: executing SEQUENCE SET folder_id_seq | |
pg_restore: executing SEQUENCE SET leak_id_seq | |
pg_restore: executing SEQUENCE SET meter_reference_id_seq | |
pg_restore: executing SEQUENCE SET node_id_seq | |
pg_restore: executing SEQUENCE SET pipe_id_seq | |
pg_restore: executing SEQUENCE SET pressurezone_id_seq | |
pg_restore: executing SEQUENCE SET printmap_id_seq | |
pg_restore: executing SEQUENCE SET protectionzone_id_seq | |
pg_restore: executing SEQUENCE SET remote_id_seq | |
pg_restore: executing SEQUENCE SET subscriber_reference_id_seq | |
pg_restore: executing SEQUENCE SET surveypoint_id_seq | |
pg_restore: executing SEQUENCE SET valve_id_seq | |
pg_restore: executing SEQUENCE SET worker_id_seq | |
pg_restore: executing SEQUENCE SET info_id_seq | |
pg_restore: executing SEQUENCE SET logged_actions_event_id_seq | |
pg_restore: executing SEQUENCE SET settings_id_seq | |
pg_restore: executing SEQUENCE SET upgrades_id_seq | |
pg_restore: creating CONSTRAINT "qwat_dr.annotationline annotationline_pkey" | |
pg_restore: creating CONSTRAINT "qwat_dr.annotationpoint annotationpoint_pkey" | |
pg_restore: creating CONSTRAINT "qwat_dr.constructionpoint constructionpoint_pkey" | |
pg_restore: creating CONSTRAINT "qwat_dr.dimension_distance dimension_distance_pkey" | |
pg_restore: creating CONSTRAINT "qwat_dr.dimension_orientation dimension_orientation_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.chamber chamber_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.consumptionzone consumptionzone_name" | |
pg_restore: creating CONSTRAINT "qwat_od.consumptionzone consumptionzone_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.cover cover_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.crossing crossing_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.damage damage_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.distributor distributor_name" | |
pg_restore: creating CONSTRAINT "qwat_od.distributor distributor_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.district district_name" | |
pg_restore: creating CONSTRAINT "qwat_od.district district_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.folder folder_identification" | |
pg_restore: creating CONSTRAINT "qwat_od.folder folder_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.hydrant hydrant_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.installation installation_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.leak leak_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.meter meter_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.meter_reference meter_reference_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.network_element network_element_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.node node_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.part part_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.pipe pipe_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.pressurecontrol pressurecontrol_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.pressurezone pressurezone_name" | |
pg_restore: creating CONSTRAINT "qwat_od.pressurezone pressurezone_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.printmap printmap_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.protectionzone protectionzone_name" | |
pg_restore: creating CONSTRAINT "qwat_od.protectionzone protectionzone_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.pump pump_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.remote remote_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.samplingpoint samplingpoint_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.source source_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.subscriber subscriber_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.subscriber_reference subscriber_reference_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.surveypoint surveypoint_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.tank tank_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.treatment treatment_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.valve valve_pkey" | |
pg_restore: creating CONSTRAINT "qwat_od.worker worker_pkey" | |
pg_restore: creating CONSTRAINT "qwat_sys.info info_pkey" | |
pg_restore: creating CONSTRAINT "qwat_sys.info info_version_excl" | |
pg_restore: creating CONSTRAINT "qwat_sys.logged_actions logged_actions_pkey" | |
pg_restore: creating CONSTRAINT "qwat_sys.logged_relations logged_relations_pkey" | |
pg_restore: creating CONSTRAINT "qwat_sys.settings setting_unique" | |
pg_restore: creating CONSTRAINT "qwat_sys.settings settings_pkey" | |
pg_restore: creating CONSTRAINT "qwat_sys.upgrades upgrades_pkey" | |
pg_restore: creating CONSTRAINT "qwat_vl.value_list_base value_list_base_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.visible visible_code" | |
pg_restore: creating CONSTRAINT "qwat_vl.visible visible_code_int" | |
pg_restore: creating CONSTRAINT "qwat_vl.bedding vl_bedding_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.cistern vl_cistern_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.cover_type vl_cover_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.hydrant_material vl_hydrant_material_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.hydrant_model_inf vl_hydrant_model_inf_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.hydrant_model_sup vl_hydrant_model_sup_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.hydrant_output vl_hydrant_output_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.hydrant_provider vl_hydrant_provider_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.leak_cause vl_leak_cause_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.locationtype vl_location_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.nominal_diameter vl_nominal_diameter_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.object_reference vl_object_reference_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.overflow vl_overflow_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.part_type vl_part_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pipe_function vl_pipe_function_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pipe_installmethod vl_pipe_installmethod_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pipe_material vl_pipe_material_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pipe_protection vl_pipe_protection_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.precision vl_precision_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.precisionalti vl_precisionalti_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pressurecontrol_type vl_pressurecontrol_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.protectionzone_type vl_protectionzone_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pump_operating vl_pump_operating_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.pump_type vl_pump_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.remote_type vl_remote_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.source_quality vl_source_quality_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.source_type vl_source_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.status vl_status_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.subscriber_type vl_subscriber_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.survey_type vl_survey_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.tank_firestorage vl_tank_firestorage_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.valve_actuation vl_valve_actuation_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.valve_function vl_valve_function_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.valve_type vl_valve_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.visible vl_visible_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.watertype vl_watertype_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.worker_type vl_worker_type_pk" | |
pg_restore: creating CONSTRAINT "qwat_vl.valve_maintenance vlvalve_maintenance_pk" | |
pg_restore: creating INDEX "qwat_dr.annotationline_geoidx" | |
pg_restore: creating INDEX "qwat_dr.annotationpoint_geoidx" | |
pg_restore: creating INDEX "qwat_dr.constructionpoint_geoidx" | |
pg_restore: creating INDEX "qwat_dr.dimension_distance_geoidx" | |
pg_restore: creating INDEX "qwat_dr.dimension_orientation_geoidx" | |
pg_restore: creating INDEX "qwat_dr.fki_constructionpoint_fk_object_reference" | |
pg_restore: creating INDEX "qwat_od.cover_geoidx" | |
pg_restore: creating INDEX "qwat_od.cover_geoidx_polygon" | |
pg_restore: creating INDEX "qwat_od.crossing_geoidx" | |
pg_restore: creating INDEX "qwat_od.district_geoidx" | |
pg_restore: creating INDEX "qwat_od.fki_cover_fk_installation" | |
pg_restore: creating INDEX "qwat_od.fki_cover_fk_object_reference" | |
pg_restore: creating INDEX "qwat_od.fki_cover_fk_precision" | |
pg_restore: creating INDEX "qwat_od.fki_cover_fk_precisionalti" | |
pg_restore: creating INDEX "qwat_od.fki_cover_fk_type" | |
pg_restore: creating INDEX "qwat_od.fki_cover_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_cover_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_district_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_district_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_element_fk_distributor" | |
pg_restore: creating INDEX "qwat_od.fki_element_fk_folder" | |
pg_restore: creating INDEX "qwat_od.fki_element_fk_object_reference" | |
pg_restore: creating INDEX "qwat_od.fki_element_fk_precision" | |
pg_restore: creating INDEX "qwat_od.fki_element_fk_precisionalti" | |
pg_restore: creating INDEX "qwat_od.fki_element_fk_status" | |
pg_restore: creating INDEX "qwat_od.fki_hydrant_fk_material" | |
pg_restore: creating INDEX "qwat_od.fki_hydrant_fk_model_inf" | |
pg_restore: creating INDEX "qwat_od.fki_hydrant_fk_model_sup" | |
pg_restore: creating INDEX "qwat_od.fki_hydrant_fk_output" | |
pg_restore: creating INDEX "qwat_od.fki_hydrant_fk_provider" | |
pg_restore: creating INDEX "qwat_od.fki_installation_fk_parent" | |
pg_restore: creating INDEX "qwat_od.fki_installation_fk_remote" | |
pg_restore: creating INDEX "qwat_od.fki_installation_watertype" | |
pg_restore: creating INDEX "qwat_od.fki_leak_fk_cause" | |
pg_restore: creating INDEX "qwat_od.fki_leak_fk_pipe" | |
pg_restore: creating INDEX "qwat_od.fki_leak_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_leak_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_meter_fk_pipe" | |
pg_restore: creating INDEX "qwat_od.fki_meter_reference_fk_meter" | |
pg_restore: creating INDEX "qwat_od.fki_network_element_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_network_element_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_node_fk_district" | |
pg_restore: creating INDEX "qwat_od.fki_node_fk_pressurezone" | |
pg_restore: creating INDEX "qwat_od.fki_part_fk_pipe" | |
pg_restore: creating INDEX "qwat_od.fki_part_fk_type" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_bedding" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_distributor" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_district" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_folder" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_function" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_installmethod" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_material" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_node_a" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_node_b" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_parent" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_precision" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_pressurezone" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_protection" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_status" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_fk_watertype" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_pipe_schema_force_visible" | |
pg_restore: creating INDEX "qwat_od.fki_pressurecontrol_type" | |
pg_restore: creating INDEX "qwat_od.fki_pressurezone_fk_consumptionzone" | |
pg_restore: creating INDEX "qwat_od.fki_pressurezone_fk_distributor" | |
pg_restore: creating INDEX "qwat_od.fki_pressurezone_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_pressurezone_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_printmap_fk_district" | |
pg_restore: creating INDEX "qwat_od.fki_printmap_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_printmap_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_protectionzone_fk_type" | |
pg_restore: creating INDEX "qwat_od.fki_pump_operating" | |
pg_restore: creating INDEX "qwat_od.fki_pump_pipe_in" | |
pg_restore: creating INDEX "qwat_od.fki_pump_pipe_out" | |
pg_restore: creating INDEX "qwat_od.fki_pump_vl_pump_type" | |
pg_restore: creating INDEX "qwat_od.fki_remote_fk_distributor" | |
pg_restore: creating INDEX "qwat_od.fki_remote_fk_material" | |
pg_restore: creating INDEX "qwat_od.fki_remote_fk_precision" | |
pg_restore: creating INDEX "qwat_od.fki_remote_fk_status" | |
pg_restore: creating INDEX "qwat_od.fki_remote_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_remote_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_source_source_quality" | |
pg_restore: creating INDEX "qwat_od.fki_source_source_type" | |
pg_restore: creating INDEX "qwat_od.fki_subscriber_fk_pipe" | |
pg_restore: creating INDEX "qwat_od.fki_subscriber_fk_type" | |
pg_restore: creating INDEX "qwat_od.fki_subscriber_reference_fk_subscriber" | |
pg_restore: creating INDEX "qwat_od.fki_surveypoint_fk_folder" | |
pg_restore: creating INDEX "qwat_od.fki_surveypoint_fk_type" | |
pg_restore: creating INDEX "qwat_od.fki_surveypoint_fk_worker" | |
pg_restore: creating INDEX "qwat_od.fki_tank_cistern1type" | |
pg_restore: creating INDEX "qwat_od.fki_tank_cistern2type" | |
pg_restore: creating INDEX "qwat_od.fki_tank_fk_overflow" | |
pg_restore: creating INDEX "qwat_od.fki_tank_fk_tank_firestorage" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_distributor" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_district" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_folder" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_function" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_handle_precision" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_handle_precisionalti" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_nominal_diameter" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_object_reference" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_pipe" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_precision" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_precisionalti" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_pressurezone" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_status" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_type" | |
pg_restore: creating INDEX "qwat_od.fki_valve_fk_valve_actuation" | |
pg_restore: creating INDEX "qwat_od.fki_valve_label_1_visible" | |
pg_restore: creating INDEX "qwat_od.fki_valve_label_2_visible" | |
pg_restore: creating INDEX "qwat_od.fki_valve_schema_force_visible" | |
pg_restore: creating INDEX "qwat_od.folder_geoidx_line" | |
pg_restore: creating INDEX "qwat_od.folder_geoidx_polygon" | |
pg_restore: creating INDEX "qwat_od.installation_poly_geoidx" | |
pg_restore: creating INDEX "qwat_od.leak_geoidx" | |
pg_restore: creating INDEX "qwat_od.meter_reference_geoidx_sch" | |
pg_restore: creating INDEX "qwat_od.node_geoidx" | |
pg_restore: creating INDEX "qwat_od.node_geoidx_alt1" | |
pg_restore: creating INDEX "qwat_od.node_geoidx_alt2" | |
pg_restore: creating INDEX "qwat_od.pipe_geoidx" | |
pg_restore: creating INDEX "qwat_od.pipe_geoidx_alt1" | |
pg_restore: creating INDEX "qwat_od.pipe_geoidx_alt2" | |
pg_restore: creating INDEX "qwat_od.pressurezone_geoidx" | |
pg_restore: creating INDEX "qwat_od.pressurezone_geoidx_alt1" | |
pg_restore: creating INDEX "qwat_od.pressurezone_geoidx_alt2" | |
pg_restore: creating INDEX "qwat_od.printmap_geoidx" | |
pg_restore: creating INDEX "qwat_od.protectionzone_geoidx" | |
pg_restore: creating INDEX "qwat_od.remote_geoidx" | |
pg_restore: creating INDEX "qwat_od.remote_geoidx_alt1" | |
pg_restore: creating INDEX "qwat_od.remote_geoidx_alt2" | |
pg_restore: creating INDEX "qwat_od.subscriber_reference_geoidx_sch" | |
pg_restore: creating INDEX "qwat_od.surveypoint_geoidx" | |
pg_restore: creating INDEX "qwat_od.valve_geoidx" | |
pg_restore: creating INDEX "qwat_od.valve_geoidx_alt1" | |
pg_restore: creating INDEX "qwat_od.valve_geoidx_alt2" | |
pg_restore: creating INDEX "qwat_od.valve_geoidx_handle" | |
pg_restore: creating INDEX "qwat_sys.logged_actions_action_idx" | |
pg_restore: creating INDEX "qwat_sys.logged_actions_action_tstamp_tx_stm_idx" | |
pg_restore: creating INDEX "qwat_sys.logged_actions_relid_idx" | |
pg_restore: creating RULE "qwat_od.vw_consumptionzone rl_consumptionzone_delete" | |
pg_restore: creating RULE "qwat_od.vw_consumptionzone rl_consumptionzone_insert" | |
pg_restore: creating RULE "qwat_od.vw_consumptionzone rl_consumptionzone_update" | |
pg_restore: creating RULE "qwat_od.pipe rl_crossing_delete" | |
pg_restore: creating RULE "qwat_od.vw_pipe_schema_visibleitems rl_pipe_delete_alternative" | |
pg_restore: creating RULE "qwat_od.vw_pipe_schema rl_pipe_schema_label" | |
pg_restore: creating RULE "qwat_od.vw_pipe_schema_visibleitems rl_pipe_update_alternative" | |
pg_restore: creating TRIGGER "qwat_dr.annotationline audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_dr.annotationpoint audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_dr.constructionpoint audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_dr.dimension_distance audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_dr.dimension_orientation audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_dr.annotationline audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_dr.annotationpoint audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_dr.constructionpoint audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_dr.dimension_distance audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_dr.dimension_orientation audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_dr.dimension_distance tr_dimension_distance" | |
pg_restore: creating COMMENT "qwat_dr.TRIGGER tr_dimension_distance ON dimension_distance" | |
pg_restore: creating TRIGGER "qwat_od.distributor audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.district audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.folder audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.leak audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.pipe audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.printmap audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.protectionzone audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.remote audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.surveypoint audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.valve audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_od.distributor audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.district audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.folder audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.leak audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.pipe audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.printmap audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.protectionzone audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.remote audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.surveypoint audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.valve audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_od.cover cover_altitude_insert_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER cover_altitude_insert_trigger ON cover" | |
pg_restore: creating TRIGGER "qwat_od.cover cover_altitude_update_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER cover_altitude_update_trigger ON cover" | |
pg_restore: creating TRIGGER "qwat_od.surveypoint surveypoint_altitude_insert_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER surveypoint_altitude_insert_trigger ON surveypoint" | |
pg_restore: creating TRIGGER "qwat_od.surveypoint surveypoint_altitude_update_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER surveypoint_altitude_update_trigger ON surveypoint" | |
pg_restore: creating TRIGGER "qwat_od.crossing tr_controled_crossing" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_hydrant tr_element_hydrant_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_hydrant tr_element_hydrant_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_hydrant tr_element_hydrant_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_installation tr_element_installation_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_installation tr_element_installation_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_installation tr_element_installation_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_meter tr_element_meter_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_meter tr_element_meter_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_meter tr_element_meter_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_part tr_element_part_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_part tr_element_part_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_part tr_element_part_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_samplingpoint tr_element_samplingpoint_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_samplingpoint tr_element_samplingpoint_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_samplingpoint tr_element_samplingpoint_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_subscriber tr_element_subscriber_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_subscriber tr_element_subscriber_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_element_subscriber tr_element_subscriber_update" | |
pg_restore: creating TRIGGER "qwat_od.leak tr_leak_pipe" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_leak_pipe ON leak" | |
pg_restore: creating TRIGGER "qwat_od.leak tr_leak_repaired" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_leak_repaired ON leak" | |
pg_restore: creating TRIGGER "qwat_od.node tr_node_altgeom_alt" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_node_altgeom_alt ON node" | |
pg_restore: creating TRIGGER "qwat_od.node tr_node_altgeom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_node_altgeom_insert ON node" | |
pg_restore: creating TRIGGER "qwat_od.node tr_node_altgeom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_node_altgeom_update ON node" | |
pg_restore: creating TRIGGER "qwat_od.vw_node_element tr_node_element_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_node_element tr_node_element_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_node_element tr_node_element_update" | |
pg_restore: creating TRIGGER "qwat_od.node tr_node_geom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_node_geom_insert ON node" | |
pg_restore: creating TRIGGER "qwat_od.node tr_node_geom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_node_geom_update ON node" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_altgeom_alt" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_altgeom_alt ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_altgeom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_altgeom_insert ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_altgeom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_altgeom_update ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_geom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_geom_insert ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_geom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_geom_update ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.node tr_pipe_node_moved" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_node_moved ON node" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_node_type_insdel" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_node_type_insdel ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_node_type_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_node_type_update ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_schema_visible_insert" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_schema_visible_update" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_pipe_tunnelbridge" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pipe_tunnelbridge ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pressurezone tr_pressurezone_altgeom_alt" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pressurezone_altgeom_alt ON pressurezone" | |
pg_restore: creating TRIGGER "qwat_od.pressurezone tr_pressurezone_altgeom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pressurezone_altgeom_insert ON pressurezone" | |
pg_restore: creating TRIGGER "qwat_od.pressurezone tr_pressurezone_altgeom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_pressurezone_altgeom_update ON pressurezone" | |
pg_restore: creating TRIGGER "qwat_od.remote tr_remote_altgeom_alt" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_remote_altgeom_alt ON remote" | |
pg_restore: creating TRIGGER "qwat_od.remote tr_remote_altgeom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_remote_altgeom_insert ON remote" | |
pg_restore: creating TRIGGER "qwat_od.remote tr_remote_altgeom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_remote_altgeom_update ON remote" | |
pg_restore: creating TRIGGER "qwat_od.tank tr_tank" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_add_pipe_vertex_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_add_pipe_vertex_insert ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_add_pipe_vertex_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_add_pipe_vertex_update ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_altgeom_alt" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_altgeom_alt ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_altgeom_insert" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_altgeom_insert ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_altgeom_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_altgeom_update ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_delete_trigger" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_infos_insert_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_infos_insert_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_infos_update_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_infos_update_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_valve_pipe_delete" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_pipe_delete ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.pipe tr_valve_pipe_update" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_pipe_update ON pipe" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_schema_visible_insert" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_schema_visible_update" | |
pg_restore: creating TRIGGER "qwat_od.valve tr_valve_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER tr_valve_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_installation tr_vw_qwat_installation_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_installation tr_vw_qwat_installation_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_installation tr_vw_qwat_installation_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_network_element tr_vw_qwat_network_element_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_network_element tr_vw_qwat_network_element_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_network_element tr_vw_qwat_network_element_update" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_node tr_vw_qwat_node_delete" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_node tr_vw_qwat_node_insert" | |
pg_restore: creating TRIGGER "qwat_od.vw_qwat_node tr_vw_qwat_node_update" | |
pg_restore: creating TRIGGER "qwat_od.valve valve_handle_altitude_insert_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER valve_handle_altitude_insert_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve valve_handle_altitude_update_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER valve_handle_altitude_update_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve valve_main_altitude_insert_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER valve_main_altitude_insert_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_od.valve valve_main_altitude_update_trigger" | |
pg_restore: creating COMMENT "qwat_od.TRIGGER valve_main_altitude_update_trigger ON valve" | |
pg_restore: creating TRIGGER "qwat_sys.settings tr_setting_create_fn_get_insert" | |
pg_restore: creating COMMENT "qwat_sys.TRIGGER tr_setting_create_fn_get_insert ON settings" | |
pg_restore: creating TRIGGER "qwat_sys.settings tr_setting_create_fn_get_update" | |
pg_restore: creating COMMENT "qwat_sys.TRIGGER tr_setting_create_fn_get_update ON settings" | |
pg_restore: creating TRIGGER "qwat_vl.cistern audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.hydrant_material audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.hydrant_provider audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.leak_cause audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.overflow audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_function audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_installmethod audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_material audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_protection audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.precision audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.pressurecontrol_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.protectionzone_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.pump_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.remote_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.source_quality audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.source_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.status audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.subscriber_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.survey_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.tank_firestorage audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.valve_actuation audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.valve_function audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.valve_maintenance audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.valve_type audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.visible audit_trigger_row" | |
pg_restore: creating TRIGGER "qwat_vl.cistern audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.hydrant_material audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.hydrant_provider audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.leak_cause audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.overflow audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_function audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_installmethod audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_material audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_protection audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.precision audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pressurecontrol_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.protectionzone_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pump_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.remote_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.source_quality audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.source_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.status audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.subscriber_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.survey_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.tank_firestorage audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.valve_actuation audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.valve_function audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.valve_maintenance audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.valve_type audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.visible audit_trigger_stm" | |
pg_restore: creating TRIGGER "qwat_vl.pipe_material tr_fancy_value" | |
pg_restore: creating COMMENT "qwat_vl.TRIGGER tr_fancy_value ON pipe_material" | |
pg_restore: creating FK CONSTRAINT "qwat_dr.constructionpoint constructionpoint_fk_object_reference" | |
pg_restore: creating FK CONSTRAINT "qwat_od.chamber chamber_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_fk_installation" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_fk_object_reference" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_fk_precision" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_fk_precisionalti" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.cover cover_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.crossing crossing_pipe1" | |
pg_restore: creating FK CONSTRAINT "qwat_od.crossing crossing_pipe2" | |
pg_restore: creating FK CONSTRAINT "qwat_od.district district_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.district district_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element element_fk_distributor" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element element_fk_folder" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element element_fk_object_reference" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element element_fk_precision" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element element_fk_precisionalti" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element element_fk_status" | |
pg_restore: creating FK CONSTRAINT "qwat_od.hydrant hydrant_fk_material" | |
pg_restore: creating FK CONSTRAINT "qwat_od.hydrant hydrant_fk_model_inf" | |
pg_restore: creating FK CONSTRAINT "qwat_od.hydrant hydrant_fk_model_sup" | |
pg_restore: creating FK CONSTRAINT "qwat_od.hydrant hydrant_fk_output" | |
pg_restore: creating FK CONSTRAINT "qwat_od.hydrant hydrant_fk_provider" | |
pg_restore: creating FK CONSTRAINT "qwat_od.hydrant hydrant_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.installation installation_fk_parent" | |
pg_restore: creating FK CONSTRAINT "qwat_od.installation installation_fk_remote" | |
pg_restore: creating FK CONSTRAINT "qwat_od.installation installation_fk_watertype" | |
pg_restore: creating FK CONSTRAINT "qwat_od.installation installation_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.leak leak_fk_cause" | |
pg_restore: creating FK CONSTRAINT "qwat_od.leak leak_fk_pipe" | |
pg_restore: creating FK CONSTRAINT "qwat_od.leak leak_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.leak leak_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.meter meter_fk_pipe" | |
pg_restore: creating FK CONSTRAINT "qwat_od.meter meter_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.meter_reference meter_reference_fk_meter" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element network_element_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element network_element_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.network_element network_element_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.node node_fk_district" | |
pg_restore: creating FK CONSTRAINT "qwat_od.node node_fk_pressurezone" | |
pg_restore: creating FK CONSTRAINT "qwat_od.part part_fk_pipe" | |
pg_restore: creating FK CONSTRAINT "qwat_od.part part_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.part part_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_bedding" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_distributor" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_district" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_folder" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_function" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_installmethod" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_material" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_node_a" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_node_b" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_parent" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_precision" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_pressurezone" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_protection" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_status" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_fk_watertype" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pipe pipe_schema_force_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pressurecontrol pressurecontrol_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pressurecontrol pressurecontrol_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pressurezone pressurezone_fk_consumptionzone" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pressurezone pressurezone_fk_distributor" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pressurezone pressurezone_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pressurezone pressurezone_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.printmap printmap_fk_district" | |
pg_restore: creating FK CONSTRAINT "qwat_od.printmap printmap_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.printmap printmap_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.protectionzone protectionzone_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pump pump_fk_pipe_in" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pump pump_fk_pipe_out" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pump pump_fk_pump_operating" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pump pump_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.pump pump_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.remote remote_fk_distributor" | |
pg_restore: creating FK CONSTRAINT "qwat_od.remote remote_fk_material" | |
pg_restore: creating FK CONSTRAINT "qwat_od.remote remote_fk_precision" | |
pg_restore: creating FK CONSTRAINT "qwat_od.remote remote_fk_status" | |
pg_restore: creating FK CONSTRAINT "qwat_od.remote remote_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.remote remote_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.samplingpoint samplingpoint_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.source source_fk_source_quality" | |
pg_restore: creating FK CONSTRAINT "qwat_od.source source_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.source source_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.subscriber subscriber_fk_pipe" | |
pg_restore: creating FK CONSTRAINT "qwat_od.subscriber subscriber_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.subscriber subscriber_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.subscriber_reference subscriber_reference_fk_subscriber" | |
pg_restore: creating FK CONSTRAINT "qwat_od.surveypoint surveypoint_fk_folder" | |
pg_restore: creating FK CONSTRAINT "qwat_od.surveypoint surveypoint_fk_object_reference" | |
pg_restore: creating FK CONSTRAINT "qwat_od.surveypoint surveypoint_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.surveypoint surveypoint_fk_worker" | |
pg_restore: creating FK CONSTRAINT "qwat_od.tank tank_cistern1type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.tank tank_cistern2type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.tank tank_fk_overflow" | |
pg_restore: creating FK CONSTRAINT "qwat_od.tank tank_fk_tank_firestorage" | |
pg_restore: creating FK CONSTRAINT "qwat_od.tank tank_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.treatment treatment_id_fkey" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_distributor" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_district" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_folder" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_function" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_handle_precision" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_handle_precisionalti" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_nominal_diameter" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_object_reference" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_pipe" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_precision" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_precisionalti" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_pressurezone" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_status" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_type" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_fk_valve_actuation" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_label_1_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_label_2_visible" | |
pg_restore: creating FK CONSTRAINT "qwat_od.valve valve_schema_force_visible" | |
pg_restore: creating ACL "qwat_od.TABLE damage" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_damage" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_hydrant" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_installation" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_leak" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_part" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_pipe" | |
pg_restore: creating ACL "qwat_sigip.TABLE vw_export_valve" | |
pg_restore: warning: errors ignored on restore: 2 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment