{"action":"created","issue":{"url":"https://api.github.com/repos/QGEP/QGEP/issues/220","repository_url":"https://api.github.com/repos/QGEP/QGEP","labels_url":"https://api.github.com/repos/QGEP/QGEP/issues/220/labels{/name}","comments_url":"https://api.github.com/repos/QGEP/QGEP/issues/220/comments","events_url":"https://api.github.com/repos/QGEP/QGEP/issues/220/events","html_url":"https://github.com/QGEP/QGEP/issues/220","id":173977926,"node_id":"MDU6SXNzdWUxNzM5Nzc5MjY=","number":220,"title":"Merging features","user":{"login":"m-kuhn","id":588407,"node_id":"MDQ6VXNlcjU4ODQwNw==","avatar_url":"https://avatars1.githubusercontent.com/u/588407?v=4","gravatar_id":"","url":"https://api.github.com/users/m-kuhn","html_url":"https://github.com/m-kuhn","followers_url":"https://api.github.com/users/m-kuhn/followers","following_url":"https://api.github.com/users/m-kuhn/following{/other_user}","gists_url":"https://api.github.com/users/m-kuhn/gists{/gist_id}","starred_url":"https://api.github.com/users/m-kuhn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/m-kuhn/subscriptions","organizations_url":"https://api.github.com/users/m-kuhn/orgs","repos_url":"https://api.github.com/users/m-kuhn/repos","events_url":"https://api.github.com/users/m-kuhn/events{/privacy}","received_events_url":"https://api.github.com/users/m-kuhn/received_events","type":"User","site_admin":false},"labels":[{"id":124940073,"node_id":"MDU6TGFiZWwxMjQ5NDAwNzM=","url":"https://api.github.com/repos/QGEP/QGEP/labels/QGIS%20Upstream","name":"QGIS Upstream","color":"d4c5f9","default":false},{"id":463949717,"node_id":"MDU6TGFiZWw0NjM5NDk3MTc=","url":"https://api.github.com/repos/QGEP/QGEP/labels/QGIS3","name":"QGIS3","color":"b60205","default":false}],"state":"open","locked":false,"assignee":{"login":"m-kuhn","id":588407,"node_id":"MDQ6VXNlcjU4ODQwNw==","avatar_url":"https://avatars1.githubusercontent.com/u/588407?v=4","gravatar_id":"","url":"https://api.github.com/users/m-kuhn","html_url":"https://github.com/m-kuhn","followers_url":"https://api.github.com/users/m-kuhn/followers","following_url":"https://api.github.com/users/m-kuhn/following{/other_user}","gists_url":"https://api.github.com/users/m-kuhn/gists{/gist_id}","starred_url":"https://api.github.com/users/m-kuhn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/m-kuhn/subscriptions","organizations_url":"https://api.github.com/users/m-kuhn/orgs","repos_url":"https://api.github.com/users/m-kuhn/repos","events_url":"https://api.github.com/users/m-kuhn/events{/privacy}","received_events_url":"https://api.github.com/users/m-kuhn/received_events","type":"User","site_admin":false},"assignees":[{"login":"m-kuhn","id":588407,"node_id":"MDQ6VXNlcjU4ODQwNw==","avatar_url":"https://avatars1.githubusercontent.com/u/588407?v=4","gravatar_id":"","url":"https://api.github.com/users/m-kuhn","html_url":"https://github.com/m-kuhn","followers_url":"https://api.github.com/users/m-kuhn/followers","following_url":"https://api.github.com/users/m-kuhn/following{/other_user}","gists_url":"https://api.github.com/users/m-kuhn/gists{/gist_id}","starred_url":"https://api.github.com/users/m-kuhn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/m-kuhn/subscriptions","organizations_url":"https://api.github.com/users/m-kuhn/orgs","repos_url":"https://api.github.com/users/m-kuhn/repos","events_url":"https://api.github.com/users/m-kuhn/events{/privacy}","received_events_url":"https://api.github.com/users/m-kuhn/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-08-30T09:59:10Z","updated_at":"2018-09-20T13:01:36Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Is not working\n\n@varrieta please fill in the details\n"},"comment":{"url":"https://api.github.com/repos/QGEP/QGEP/issues/comments/423174322","html_url":"https://github.com/QGEP/QGEP/issues/220#issuecomment-423174322","issue_url":"https://api.github.com/repos/QGEP/QGEP/issues/220","id":423174322,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMzE3NDMyMg==","user":{"login":"m-kuhn","id":588407,"node_id":"MDQ6VXNlcjU4ODQwNw==","avatar_url":"https://avatars1.githubusercontent.com/u/588407?v=4","gravatar_id":"","url":"https://api.github.com/users/m-kuhn","html_url":"https://github.com/m-kuhn","followers_url":"https://api.github.com/users/m-kuhn/followers","following_url":"https://api.github.com/users/m-kuhn/following{/other_user}","gists_url":"https://api.github.com/users/m-kuhn/gists{/gist_id}","starred_url":"https://api.github.com/users/m-kuhn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/m-kuhn/subscriptions","organizations_url":"https://api.github.com/users/m-kuhn/orgs","repos_url":"https://api.github.com/users/m-kuhn/repos","events_url":"https://api.github.com/users/m-kuhn/events{/privacy}","received_events_url":"https://api.github.com/users/m-kuhn/received_events","type":"User","site_admin":false},"created_at":"2018-09-20T13:01:36Z","updated_at":"2018-09-20T13:01:36Z","author_association":"CONTRIBUTOR","body":"> Tried to merge two selected reaches. There is a window where you can choose, which attribute is copied from which record. If I do no changes, then I get this error:\r\n> \r\n> Layer vw_qgep_reach: PostGIS-Fehler beim Attributhinzufügen: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »pkey_qgep_od_wastewater_structure_obj_id« DETAIL: Schlüssel »(obj_id)=(00000000CL017726)« existiert bereits. CONTEXT: SQL-Anweisung »INSERT INTO qgep_od.wastewater_structure ( obj_id , accessibility , contract_section -- , detail_geometry_geometry , financing , gross_costs , identifier , inspection_interval , location_name , records , remark , renovation_necessity , replacement_value , rv_base_year , rv_construction_type , status , structure_condition , subsidies , year_of_construction , year_of_replacement -- , last_modification -- , fk_dataowner -- , fk_provider , fk_owner , fk_operator ) VALUES ( COALESCE(NEW.fk_wastewater_structure,qgep_sys.generate_oid('qgep_od','channel')) -- obj_id , NEW.ws_accessibility , NEW.ws_contract_section -- , NEW.detail_geometry_geometry , NEW.ws_financing , NEW.ws_gross_costs , NEW.ws_identifier , NEW.ws_inspection_interval , NEW.ws_location_name , NEW.ws_records , NEW.ws_remark , NEW.ws_renovation_necessity , NEW.ws_replacement_value , NEW.ws_rv_base_year , NEW.ws_rv_construction_type , NEW.ws_status , NEW.ws_structure_condition , NEW.ws_subsidies , NEW.ws_year_of_construction , NEW.ws_year_of_replacement -- , NEW.ws_last_modification -- , NEW.fk_dataowner -- , NEW.fk_provider , NEW.ws_fk_owner , NEW.ws_fk_operator ) RETURNING obj_id« PL/pgSQL-Funktion qgep_od.vw_qgep_reach_insert() Zeile 64 bei SQL-Anweisung\r\n> \r\n> The problem is, that the two selected reaches where deleted and then a new record is created. Because the deleting of the reach does not delete also the channel, the wastewater_structure, the reach_points and the wastewater_networkelement, the channel -obj_id still exists.\r\nIf I change in the described window the channel-obj_id, then there is no more error and I get a new reach with the choosen attributes. But there remains the problems with fk to the deleted reaches (because these fk are not to the reach-table, but to the wastewater_networkelement - where the upper-class-record of the deleted reaches still exists...) -> #436 is really important\r\n\r\nhttps://github.com/QGEP/QGEP/issues/450"}}
{"actor":{"display_login":"m-kuhn"}}