{"action":"opened","issue":{"url":"https://api.github.com/repos/opengeogroep/NLExtract/issues/170","labels_url":"https://api.github.com/repos/opengeogroep/NLExtract/issues/170/labels{/name}","comments_url":"https://api.github.com/repos/opengeogroep/NLExtract/issues/170/comments","events_url":"https://api.github.com/repos/opengeogroep/NLExtract/issues/170/events","html_url":"https://github.com/opengeogroep/NLExtract/issues/170","id":126671322,"number":170,"title":"Fout bij dedupliceren BGT-data","user":{"login":"fsteggink","id":1371655,"avatar_url":"https://avatars.githubusercontent.com/u/1371655?v=3","gravatar_id":"","url":"https://api.github.com/users/fsteggink","html_url":"https://github.com/fsteggink","followers_url":"https://api.github.com/users/fsteggink/followers","following_url":"https://api.github.com/users/fsteggink/following{/other_user}","gists_url":"https://api.github.com/users/fsteggink/gists{/gist_id}","starred_url":"https://api.github.com/users/fsteggink/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fsteggink/subscriptions","organizations_url":"https://api.github.com/users/fsteggink/orgs","repos_url":"https://api.github.com/users/fsteggink/repos","events_url":"https://api.github.com/users/fsteggink/events{/privacy}","received_events_url":"https://api.github.com/users/fsteggink/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/opengeogroep/NLExtract/labels/bgt-extract","name":"bgt-extract","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-14T15:01:39Z","updated_at":"2016-01-14T15:01:39Z","closed_at":null,"body":"Output van Stetl:\r\n```\r\n2016-01-14 15:58:23,769 dboutput INFO executing SQL\r\n2016-01-14 15:58:23,769 postgis INFO Connecting to dbname=bgt user=bgt host=loca\r\nlhost port=5432\r\n2016-01-14 15:58:23,786 postgis DEBUG Connected to database bgt\r\n2016-01-14 15:58:23,786 postgis ERROR error relation \"bak\" does not exist\r\nLINE 1: ... TABLE _nlx_temp AS SELECT ogc_fid, lokaalid FROM bak WHERE ...\r\n                                                             ^\r\nQUERY:  CREATE TABLE _nlx_temp AS SELECT ogc_fid, lokaalid FROM bak WHERE lokaal\r\nid IN (SELECT lokaalid FROM (SELECT lokaalid, COUNT(*) AS aantal FROM bak GROUP\r\nBY lokaalid ORDER BY lokaalid) AS x WHERE aantal>1);\r\nCONTEXT:  PL/pgSQL function \"_nlx_dedup_data\" line 6 at EXECUTE statement\r\n in query: -- Auteur: Frank Steggink\r\n-- Doel: script om dubbele records te verwijderen, middels een hulptabel\r\n\r\nSET search_path=bgt,public;\r\n(etc.)\r\n```\r\n\r\nOplossing: aan PLPGSQL-blok een check toevoegen of de tabel waar duplicaten uit verwijderd moeten worden ook inderdaad bestaat."}}