{"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: navicat compatibility","user":{"login":"joel-custlabs","id":15796953,"avatar_url":"https://avatars0.githubusercontent.com/u/15796953?v=4","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/A-pg-compat","name":"A-pg-compat","color":"22aa88","default":false},{"id":912328329,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/C-question","name":"C-question","color":"c5def5","default":false},{"id":560660618,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/O-community","name":"O-community","color":"666ad1","default":false},{"id":912283375,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/meta-issue","name":"meta-issue","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":{"login":"awoods187","id":22278911,"avatar_url":"https://avatars1.githubusercontent.com/u/22278911?v=4","gravatar_id":"","url":"https://api.github.com/users/awoods187","html_url":"https://github.com/awoods187","followers_url":"https://api.github.com/users/awoods187/followers","following_url":"https://api.github.com/users/awoods187/following{/other_user}","gists_url":"https://api.github.com/users/awoods187/gists{/gist_id}","starred_url":"https://api.github.com/users/awoods187/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/awoods187/subscriptions","organizations_url":"https://api.github.com/users/awoods187/orgs","repos_url":"https://api.github.com/users/awoods187/repos","events_url":"https://api.github.com/users/awoods187/events{/privacy}","received_events_url":"https://api.github.com/users/awoods187/received_events","type":"User","site_admin":false},"assignees":[{"login":"awoods187","id":22278911,"avatar_url":"https://avatars1.githubusercontent.com/u/22278911?v=4","gravatar_id":"","url":"https://api.github.com/users/awoods187","html_url":"https://github.com/awoods187","followers_url":"https://api.github.com/users/awoods187/followers","following_url":"https://api.github.com/users/awoods187/following{/other_user}","gists_url":"https://api.github.com/users/awoods187/gists{/gist_id}","starred_url":"https://api.github.com/users/awoods187/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/awoods187/subscriptions","organizations_url":"https://api.github.com/users/awoods187/orgs","repos_url":"https://api.github.com/users/awoods187/repos","events_url":"https://api.github.com/users/awoods187/events{/privacy}","received_events_url":"https://api.github.com/users/awoods187/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/13","html_url":"https://github.com/cockroachdb/cockroach/milestone/13","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/13/labels","id":2745639,"number":13,"title":"2.1","description":"","creator":{"login":"knz","id":642886,"avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"open_issues":562,"closed_issues":202,"state":"open","created_at":"2017-09-05T15:30:49Z","updated_at":"2018-05-05T01:29:42Z","due_on":null,"closed_at":null},"comments":20,"created_at":"2016-03-25T20:55:16Z","updated_at":"2018-05-05T01:29:49Z","closed_at":null,"author_association":"NONE","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/386769756","html_url":"https://github.com/cockroachdb/cockroach/issues/5583#issuecomment-386769756","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/5583","id":386769756,"user":{"login":"knz","id":642886,"avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"created_at":"2018-05-05T01:29:49Z","updated_at":"2018-05-05T01:29:49Z","author_association":"OWNER","body":"sorry wrong click\r\n"}}
{"actor":{"display_login":"knz"}}