pgcli: Can't connect to Greenplum server (psycopg2.ProgrammingError: column d.datcollate does not exist)
So, after getting past the jedi issue, I got pgcli to work on a local PostgreSQL instance. I’m now trying to connect to a 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:
$ pgcli postgresql://[username]:[password]@[host]/[dbname]
Traceback (most recent call last):
File "/usr/local/bin/pgcli", line 9, in <module>
load_entry_point('pgcli==0.10.0', 'console_scripts', 'pgcli')()
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 610, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 590, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 782, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 416, in invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/pgcli/main.py", line 86, in cli
refresh_completions(pgexecute, completer)
File "/usr/local/lib/python2.7/site-packages/pgcli/main.py", line 180, in refresh_completions
completer.extend_database_names(pgexecute.databases())
File "/usr/local/lib/python2.7/site-packages/pgcli/pgexecute.py", line 138, in databases
cur.execute(self.databases_query)
psycopg2.ProgrammingError: column d.datcollate does not exist
LINE 4: d.datcollate as "Collate",
Googling seems to turn up nothing.
Thanks again for your time.
About this issue
- Original URL
- State: closed
- Created 9 years ago
- Comments: 19 (7 by maintainers)
This is now available in v1.0. Please upgrade.