Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ibis.postgres table expressions dont recognize inet datatype #2462

Closed
esamuel1 opened this issue Oct 12, 2020 · 1 comment
Closed

ibis.postgres table expressions dont recognize inet datatype #2462

esamuel1 opened this issue Oct 12, 2020 · 1 comment
Labels
postgres The PostgreSQL backend refactor Issues or PRs related to refactoring the codebase

Comments

@esamuel1
Copy link

esamuel1 commented Oct 12, 2020

xref #2461

Impacts ibis 1.3.0

Ibis doesn't appear to recognize inet data types in postgres when trying to build an ibis table expression. A simple reproduction of the issue is below:

pgcon = ibis.postgres.connect(
    database=database,
    host=host,
    user=user,
    password=password,
    port=port
)

tblnm='iptbl'
iptbl='''
create table if not exists {} (
sometime timestamp,aip inet);
'''.format(tblnm)
pgcon.raw_sql(iptbl)
iptblibis=pgcon.table(tblnm)
NotImplementedError: Could not find signature for dtype: <PGDialect_psycopg2, INET>
Looking at the sqlalchemy docs, it seems they do support inet for postgres.
@datapythonista datapythonista added postgres The PostgreSQL backend refactor Issues or PRs related to refactoring the codebase labels Oct 12, 2020
@cpcloud
Copy link
Member

cpcloud commented Dec 16, 2021

Didn't get caught by GitHub in the merge.

@cpcloud cpcloud closed this as completed Dec 16, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
postgres The PostgreSQL backend refactor Issues or PRs related to refactoring the codebase
Projects
None yet
Development

No branches or pull requests

3 participants