{"action":"opened","issue":{"url":"https://api.github.com/repos/amjith/pgcli/issues/18","labels_url":"https://api.github.com/repos/amjith/pgcli/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/amjith/pgcli/issues/18/comments","events_url":"https://api.github.com/repos/amjith/pgcli/issues/18/events","html_url":"https://github.com/amjith/pgcli/issues/18","id":53539608,"number":18,"title":"Can't connect to Greenplum server (psycopg2.ProgrammingError: column d.datcollate does not exist)","user":{"login":"jackmaney","id":1554625,"avatar_url":"https://avatars.githubusercontent.com/u/1554625?v=3","gravatar_id":"","url":"https://api.github.com/users/jackmaney","html_url":"https://github.com/jackmaney","followers_url":"https://api.github.com/users/jackmaney/followers","following_url":"https://api.github.com/users/jackmaney/following{/other_user}","gists_url":"https://api.github.com/users/jackmaney/gists{/gist_id}","starred_url":"https://api.github.com/users/jackmaney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jackmaney/subscriptions","organizations_url":"https://api.github.com/users/jackmaney/orgs","repos_url":"https://api.github.com/users/jackmaney/repos","events_url":"https://api.github.com/users/jackmaney/events{/privacy}","received_events_url":"https://api.github.com/users/jackmaney/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-01-06T17:30:07Z","updated_at":"2015-01-06T17:30:07Z","closed_at":null,"body":"So, after [getting past the `jedi` issue](https://github.com/amjith/pgcli/issues/16), I got pgcli to work on a local PostgreSQL instance. I'm now trying to connect to a [Greenplum database](http://www.pivotal.io/big-data/pivotal-greenplum-database) (a distributed database built on top of PostgreSQL. Anything that can talk to vanilla Postgres should be able to talk to Greenplum...I've had no issues with, eg, pgAdmin or psycopg2). Here's what happens:\r\n\r\n```\r\n$ pgcli postgresql://[username]:[password]@[host]/[dbname]\r\nTraceback (most recent call last):\r\n  File \"/usr/local/bin/pgcli\", line 9, in <module>\r\n    load_entry_point('pgcli==0.10.0', 'console_scripts', 'pgcli')()\r\n  File \"/usr/local/lib/python2.7/site-packages/click/core.py\", line 610, in __call__\r\n    return self.main(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/site-packages/click/core.py\", line 590, in main\r\n    rv = self.invoke(ctx)\r\n  File \"/usr/local/lib/python2.7/site-packages/click/core.py\", line 782, in invoke\r\n    return ctx.invoke(self.callback, **ctx.params)\r\n  File \"/usr/local/lib/python2.7/site-packages/click/core.py\", line 416, in invoke\r\n    return callback(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/site-packages/pgcli/main.py\", line 86, in cli\r\n    refresh_completions(pgexecute, completer)\r\n  File \"/usr/local/lib/python2.7/site-packages/pgcli/main.py\", line 180, in refresh_completions\r\n    completer.extend_database_names(pgexecute.databases())\r\n  File \"/usr/local/lib/python2.7/site-packages/pgcli/pgexecute.py\", line 138, in databases\r\n    cur.execute(self.databases_query)\r\npsycopg2.ProgrammingError: column d.datcollate does not exist\r\nLINE 4:        d.datcollate as \"Collate\",\r\n```\r\n\r\nGoogling seems to turn up nothing.\r\n\r\nThanks again for your time."}}