Arch Linux User Repository

pgcli broke again. sqlparse dependency changed to sqlparse<0.4,>=0.3.0, but the current package is at '0.2.4` (Someone already flagged out of date: https://www.archlinux.org/packages/community/any/python-sqlparse/) .

Full error message on pgcli start:

Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 583, in _build_master
    ws.require(__requires__)
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 900, in require
    needed = self.resolve(parse_requirements(requirements))
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 791, in resolve
    raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (sqlparse 0.2.4 (/usr/lib/python3.7/site-packages), Requirement.parse('sqlparse<0.4,>=0.3.0'), {'pgcli'})

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/bin/pgcli", line 6, in <module>
    from pkg_resources import load_entry_point
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 3241, in <module>
    @_call_aside
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 3225, in _call_aside
    f(*args, **kwargs)
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 3254, in _initialize_master_working_set
    working_set = WorkingSet._build_master()
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 585, in _build_master
    return cls._build_from_requirements(__requires__)
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 598, in _build_from_requirements
    dists = ws.resolve(reqs, Environment())
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 786, in resolve
    raise DistributionNotFound(req, requirers)
pkg_resources.DistributionNotFound: The 'sqlparse<0.4,>=0.3.0' distribution was not found and is required by pgcli

@asm0dey yeap, no problem ... Since this is a somewhat breaking change - renaming and/or changing the distribution format of the package, done in psycopg2 2.8 ... Anyway, indeed we have to wait :-)

So, waiting for fix in upstream. Sorry, folks

@asm0dey more info about that here: https://github.com/dbcli/pgcli/issues/1036

@asm0dey I switched to pgcli-git for now because the latest stable release (2.1.0) has the psycopg2 version tagged inside setup.py like this:

install_requirements = [
    'pgspecial>=1.11.5',
    'click >= 4.1',
    'Pygments >= 2.0',  # Pygments has to be Capitalcased. WTF?
    'prompt_toolkit>=2.0.6,<2.1.0',
    'psycopg2 >= 2.7.4,<2.8',
    'sqlparse >=0.2.2,<0.3.0',
    'configobj >= 5.0.6',
    'humanize >= 0.5.1',
    'cli_helpers[styles] >= 1.2.0',
]

Sorry about the "WTF?" in there, I just copied the code as is.

Another solution would be to downgrade your psycopg2 version from your pacman cache or from the archives. I really don't know exactly why the pgcli-git works because the codebase in the master branch has the same requirements as the latest release. Anyway, it is working (I just don't know at what extent) with psycopg2==2.8.1 in my local machine.

@vltr any ideas on how to fix it?

pgcli is broken today (20190410) since python-psycopg2 was upgraded in the community repo to version 2.8.1, making it incompatible with pgcli 2.1.0:

Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 583, in _build_master
    ws.require(__requires__)
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 900, in require
    needed = self.resolve(parse_requirements(requirements))
  File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 791, in resolve
    raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (psycopg2 2.8.1 (/usr/lib/python3.7/site-packages), Requirement.parse('psycopg2<2.8,>=2.7.4'), {'pgcli'})

Thank you for report

Yep, it's working fine. Thanks!

@Quatro please try again