Skip to content
This repository has been archived by the owner on Feb 18, 2024. It is now read-only.

Postgres connection not working #8

Closed
spren9er opened this issue Aug 30, 2022 · 1 comment
Closed

Postgres connection not working #8

spren9er opened this issue Aug 30, 2022 · 1 comment
Labels
bug Something isn't working fixed

Comments

@spren9er
Copy link

I tried to connect to a local PostgreSQL database via

vdsql postgres://localhost:5432/my_db

but following error occurred:

Traceback (most recent call last):
  File "/Users/spren9er/.local/share/virtualenvs/vd-UPn86r9P/bin/vdsql", line 15, in <module>
    main.vd_cli()
  File "/Users/spren9er/.local/share/virtualenvs/vd-UPn86r9P/lib/python3.9/site-packages/visidata/main.py", line 350, in vd_cli
    rc = main_vd()
  File "/Users/spren9er/.local/share/virtualenvs/vd-UPn86r9P/lib/python3.9/site-packages/visidata/main.py", line 241, in main_vd
    vs = vd.openSource(p, create=True, **opts) or vd.fail(f'could not open {p}')
  File "/Users/spren9er/.local/share/virtualenvs/vd-UPn86r9P/lib/python3.9/site-packages/visidata/_open.py", line 95, in openSource
    vs = vd.openPath(Path(p), filetype=filetype)  # convert to Path and recurse
  File "/Users/spren9er/.local/share/virtualenvs/vd-UPn86r9P/lib/python3.9/site-packages/visidata/_open.py", line 50, in openPath
    return openfunc(p, filetype=filetype)
TypeError: open_vdsql() got an unexpected keyword argument 'filetype'

Database connection works in principle. Following command is successful without any issues

vd postgres://localhost:5432/my_db

but this is using psycopg2 and not ibis framework.

@saulpw
Copy link
Owner

saulpw commented Aug 30, 2022

Hi @spren9er, thanks for reporting this bug; this should be fixed in the develop branch. It will be in v0.2, which we are planning to release soon.

@saulpw saulpw closed this as completed Aug 30, 2022
@anjakefala anjakefala added bug Something isn't working fixed labels Aug 30, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working fixed
Projects
None yet
Development

No branches or pull requests

3 participants