{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/5583","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/5583/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/5583/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/5583/events","html_url":"https://github.com/cockroachdb/cockroach/issues/5583","id":143595834,"number":5583,"title":"sql/pgwire: database auto-discovery via pg_database & pg_tablespace tables","user":{"login":"joel-custlabs","id":15796953,"avatar_url":"https://avatars.githubusercontent.com/u/15796953?v=3","gravatar_id":"","url":"https://api.github.com/users/joel-custlabs","html_url":"https://github.com/joel-custlabs","followers_url":"https://api.github.com/users/joel-custlabs/followers","following_url":"https://api.github.com/users/joel-custlabs/following{/other_user}","gists_url":"https://api.github.com/users/joel-custlabs/gists{/gist_id}","starred_url":"https://api.github.com/users/joel-custlabs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joel-custlabs/subscriptions","organizations_url":"https://api.github.com/users/joel-custlabs/orgs","repos_url":"https://api.github.com/users/joel-custlabs/repos","events_url":"https://api.github.com/users/joel-custlabs/events{/privacy}","received_events_url":"https://api.github.com/users/joel-custlabs/received_events","type":"User","site_admin":false},"labels":[{"id":464498682,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/orm-support","name":"orm-support","color":"22aa88","default":false}],"state":"open","locked":false,"assignee":{"login":"nvanbenschoten","id":5438456,"avatar_url":"https://avatars.githubusercontent.com/u/5438456?v=3","gravatar_id":"","url":"https://api.github.com/users/nvanbenschoten","html_url":"https://github.com/nvanbenschoten","followers_url":"https://api.github.com/users/nvanbenschoten/followers","following_url":"https://api.github.com/users/nvanbenschoten/following{/other_user}","gists_url":"https://api.github.com/users/nvanbenschoten/gists{/gist_id}","starred_url":"https://api.github.com/users/nvanbenschoten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvanbenschoten/subscriptions","organizations_url":"https://api.github.com/users/nvanbenschoten/orgs","repos_url":"https://api.github.com/users/nvanbenschoten/repos","events_url":"https://api.github.com/users/nvanbenschoten/events{/privacy}","received_events_url":"https://api.github.com/users/nvanbenschoten/received_events","type":"User","site_admin":false},"assignees":[{"login":"nvanbenschoten","id":5438456,"avatar_url":"https://avatars.githubusercontent.com/u/5438456?v=3","gravatar_id":"","url":"https://api.github.com/users/nvanbenschoten","html_url":"https://github.com/nvanbenschoten","followers_url":"https://api.github.com/users/nvanbenschoten/followers","following_url":"https://api.github.com/users/nvanbenschoten/following{/other_user}","gists_url":"https://api.github.com/users/nvanbenschoten/gists{/gist_id}","starred_url":"https://api.github.com/users/nvanbenschoten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvanbenschoten/subscriptions","organizations_url":"https://api.github.com/users/nvanbenschoten/orgs","repos_url":"https://api.github.com/users/nvanbenschoten/repos","events_url":"https://api.github.com/users/nvanbenschoten/events{/privacy}","received_events_url":"https://api.github.com/users/nvanbenschoten/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/5","html_url":"https://github.com/cockroachdb/cockroach/milestones/Q3","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/5/labels","id":1875804,"number":5,"title":"Q3","description":"","creator":{"login":"petermattis","id":6201335,"avatar_url":"https://avatars.githubusercontent.com/u/6201335?v=3","gravatar_id":"","url":"https://api.github.com/users/petermattis","html_url":"https://github.com/petermattis","followers_url":"https://api.github.com/users/petermattis/followers","following_url":"https://api.github.com/users/petermattis/following{/other_user}","gists_url":"https://api.github.com/users/petermattis/gists{/gist_id}","starred_url":"https://api.github.com/users/petermattis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermattis/subscriptions","organizations_url":"https://api.github.com/users/petermattis/orgs","repos_url":"https://api.github.com/users/petermattis/repos","events_url":"https://api.github.com/users/petermattis/events{/privacy}","received_events_url":"https://api.github.com/users/petermattis/received_events","type":"User","site_admin":false},"open_issues":103,"closed_issues":309,"state":"open","created_at":"2016-07-11T13:25:51Z","updated_at":"2016-11-11T02:34:21Z","due_on":"2016-10-01T04:00:00Z","closed_at":null},"comments":7,"created_at":"2016-03-25T20:55:16Z","updated_at":"2016-11-22T23:14:51Z","closed_at":null,"body":"To repro:\n- Open navicat ( http://www.navicat.com/download/navicat-for-postgresql )\n- Attempt to connect to a cockroachdb instance\n\nExpected results:\n- Displays cockroach server's databases\n\nObserved results:\n- ERROR: sql/select.go:354 (pmattis): unsupported FROM: FROM pg_database AS d LEFT JOIN pg_tablespace AS t ON d.dattablespace = t.oid\n\nAdding support for database / table auto-discovery would allow the entire postgres toolchain / ecosystem to work against cockroach, which might significantly increase adoption.\n"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/262394572","html_url":"https://github.com/cockroachdb/cockroach/issues/5583#issuecomment-262394572","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/5583","id":262394572,"user":{"login":"jordanlewis","id":43821,"avatar_url":"https://avatars.githubusercontent.com/u/43821?v=3","gravatar_id":"","url":"https://api.github.com/users/jordanlewis","html_url":"https://github.com/jordanlewis","followers_url":"https://api.github.com/users/jordanlewis/followers","following_url":"https://api.github.com/users/jordanlewis/following{/other_user}","gists_url":"https://api.github.com/users/jordanlewis/gists{/gist_id}","starred_url":"https://api.github.com/users/jordanlewis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jordanlewis/subscriptions","organizations_url":"https://api.github.com/users/jordanlewis/orgs","repos_url":"https://api.github.com/users/jordanlewis/repos","events_url":"https://api.github.com/users/jordanlewis/events{/privacy}","received_events_url":"https://api.github.com/users/jordanlewis/received_events","type":"User","site_admin":false},"created_at":"2016-11-22T23:14:51Z","updated_at":"2016-11-22T23:14:51Z","body":"Yes, we can likely get to this at some point soon.\r\n\r\nThere's one more thing you can do to help us help you quicker, if you have the time: perform a sample run of navicat against a sample postgres database and log the queries. If you put those queries in a gist and link it here we can finish the issue triage - it would be a shame if we implemented these three functions only to run into a stumbling block in the next query that navicat executes after the one you pasted."}}
{"actor":{"display_login":"jordanlewis"}}