{"action":"created","issue":{"url":"https://api.github.com/repos/tilemill-project/tilemill/issues/2628","repository_url":"https://api.github.com/repos/tilemill-project/tilemill","labels_url":"https://api.github.com/repos/tilemill-project/tilemill/issues/2628/labels{/name}","comments_url":"https://api.github.com/repos/tilemill-project/tilemill/issues/2628/comments","events_url":"https://api.github.com/repos/tilemill-project/tilemill/issues/2628/events","html_url":"https://github.com/tilemill-project/tilemill/issues/2628","id":354665493,"node_id":"MDU6SXNzdWUzNTQ2NjU0OTM=","number":2628,"title":"Postgis Plugin: ERROR:  function st_srid(bytea) is not unique","user":{"login":"Qtianv587","id":18344424,"node_id":"MDQ6VXNlcjE4MzQ0NDI0","avatar_url":"https://avatars3.githubusercontent.com/u/18344424?v=4","gravatar_id":"","url":"https://api.github.com/users/Qtianv587","html_url":"https://github.com/Qtianv587","followers_url":"https://api.github.com/users/Qtianv587/followers","following_url":"https://api.github.com/users/Qtianv587/following{/other_user}","gists_url":"https://api.github.com/users/Qtianv587/gists{/gist_id}","starred_url":"https://api.github.com/users/Qtianv587/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Qtianv587/subscriptions","organizations_url":"https://api.github.com/users/Qtianv587/orgs","repos_url":"https://api.github.com/users/Qtianv587/repos","events_url":"https://api.github.com/users/Qtianv587/events{/privacy}","received_events_url":"https://api.github.com/users/Qtianv587/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-08-28T10:21:29Z","updated_at":"2018-10-26T23:50:54Z","closed_at":"2018-10-26T23:50:54Z","author_association":"NONE","body":"I tried to add a postgis layer and I filled the parameters like this:\r\n```\r\nconnection: host=xxx.xxx.xxx.xxx port=5432 user=xxx password=xxx dbname=enc\r\n\r\ntable or subquery: rivers\r\n\r\nGeometry field: wkb_geometry\r\n\r\nExtent: Pre-calculate\r\n\r\nSRS: WGS84\r\n```\r\n\r\nOther parameters remains blank.\r\n\r\nAnd the error message is:\r\n\r\n```\r\nPostgis Plugin: ERROR:  function st_srid(bytea) is not unique\r\nLINE 1: SELECT ST_SRID(\"wkb_geometry\") AS srid FROM rivers WHERE \"wk...\r\n               ^\r\nHINT:  Could not choose a best candidate function. You might need to add explicit type casts.\r\nin executeQuery Full sql was: 'SELECT ST_SRID(\"wkb_geometry\") AS srid FROM rivers WHERE \"wkb_geometry\" IS NOT NULL LIMIT 1;'\r\n```\r\n\r\nI tried all ways to handle it but failed. Can someone solve this? @springmeyer "},"comment":{"url":"https://api.github.com/repos/tilemill-project/tilemill/issues/comments/433571611","html_url":"https://github.com/tilemill-project/tilemill/issues/2628#issuecomment-433571611","issue_url":"https://api.github.com/repos/tilemill-project/tilemill/issues/2628","id":433571611,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMzU3MTYxMQ==","user":{"login":"csytsma","id":128836,"node_id":"MDQ6VXNlcjEyODgzNg==","avatar_url":"https://avatars3.githubusercontent.com/u/128836?v=4","gravatar_id":"","url":"https://api.github.com/users/csytsma","html_url":"https://github.com/csytsma","followers_url":"https://api.github.com/users/csytsma/followers","following_url":"https://api.github.com/users/csytsma/following{/other_user}","gists_url":"https://api.github.com/users/csytsma/gists{/gist_id}","starred_url":"https://api.github.com/users/csytsma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csytsma/subscriptions","organizations_url":"https://api.github.com/users/csytsma/orgs","repos_url":"https://api.github.com/users/csytsma/repos","events_url":"https://api.github.com/users/csytsma/events{/privacy}","received_events_url":"https://api.github.com/users/csytsma/received_events","type":"User","site_admin":false},"created_at":"2018-10-26T23:50:54Z","updated_at":"2018-10-26T23:50:54Z","author_association":"MEMBER","body":"Thanks for posting an update with your resolution."}}
{"actor":{"display_login":"csytsma"}}