{"action":"created","issue":{"url":"https://api.github.com/repos/d4software/QueryTree/issues/14","repository_url":"https://api.github.com/repos/d4software/QueryTree","labels_url":"https://api.github.com/repos/d4software/QueryTree/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/d4software/QueryTree/issues/14/comments","events_url":"https://api.github.com/repos/d4software/QueryTree/issues/14/events","html_url":"https://github.com/d4software/QueryTree/issues/14","id":321826299,"number":14,"title":"trying to query greenplum DB using the postgres connector not working","user":{"login":"whitemark","id":13211752,"avatar_url":"https://avatars3.githubusercontent.com/u/13211752?v=4","gravatar_id":"","url":"https://api.github.com/users/whitemark","html_url":"https://github.com/whitemark","followers_url":"https://api.github.com/users/whitemark/followers","following_url":"https://api.github.com/users/whitemark/following{/other_user}","gists_url":"https://api.github.com/users/whitemark/gists{/gist_id}","starred_url":"https://api.github.com/users/whitemark/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/whitemark/subscriptions","organizations_url":"https://api.github.com/users/whitemark/orgs","repos_url":"https://api.github.com/users/whitemark/repos","events_url":"https://api.github.com/users/whitemark/events{/privacy}","received_events_url":"https://api.github.com/users/whitemark/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-05-10T06:39:16Z","updated_at":"2018-05-10T13:33:58Z","closed_at":null,"author_association":"NONE","body":"Hello\r\nI have an instance of GreenPlum DB, it is based on postgres 8.3x, \r\nI tried to connect QueryTree but i have no luck, testing the connection looks good but when I try to create a new report, QueryTree does not show any table in the \"Select your Tables\" panel\r\n\r\nCould you kindly help me with this?\r\n\r\nThanks heap!\r\nBest regards\r\n Mark "},"comment":{"url":"https://api.github.com/repos/d4software/QueryTree/issues/comments/388054495","html_url":"https://github.com/d4software/QueryTree/issues/14#issuecomment-388054495","issue_url":"https://api.github.com/repos/d4software/QueryTree/issues/14","id":388054495,"user":{"login":"dand4","id":20768727,"avatar_url":"https://avatars0.githubusercontent.com/u/20768727?v=4","gravatar_id":"","url":"https://api.github.com/users/dand4","html_url":"https://github.com/dand4","followers_url":"https://api.github.com/users/dand4/followers","following_url":"https://api.github.com/users/dand4/following{/other_user}","gists_url":"https://api.github.com/users/dand4/gists{/gist_id}","starred_url":"https://api.github.com/users/dand4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dand4/subscriptions","organizations_url":"https://api.github.com/users/dand4/orgs","repos_url":"https://api.github.com/users/dand4/repos","events_url":"https://api.github.com/users/dand4/events{/privacy}","received_events_url":"https://api.github.com/users/dand4/received_events","type":"User","site_admin":false},"created_at":"2018-05-10T13:33:58Z","updated_at":"2018-05-10T13:33:58Z","author_association":"CONTRIBUTOR","body":"Ok, so I ran the Greenplumb docker image, created a table named test (in the gpadmin schema)\r\n\r\n```\r\ncreate table test\r\n(\r\n  id          serial (10) default nextval('test_id_seq':: regclass ) not null\r\n  constraint test_pkey\r\n  primary key,\r\n  name        varchar(50),\r\n  description varchar(250)\r\n);\r\n```\r\n\r\nand connected QueryTree to it, and all seems well:\r\n\r\n<img width=\"612\" alt=\"screen shot 2018-05-10 at 14 27 29\" src=\"https://user-images.githubusercontent.com/20768727/39871987-7af7844e-545e-11e8-8949-5952dadefdc1.png\">\r\n\r\nMaybe there's something specific in your schema that's causing a problem. Perhaps you could create a new schema, point QueryTree at it, and then add some of your tables, checking QueryTree each time, until you find the one that causes QueryTree to fall over. Then you could send me the SQL and we can figure out why QueryTree doesn't like it."}}
{"actor":{"display_login":"dand4"}}