Skip to content

connectorx generate error when fetching values from columns with tsrange data type #429

Open
@shoaibb

Description

What language are you using?

Python.

What version are you using?

3.8.5

What database are you using?

PostgreSQL

What dataframe are you using?

Pandas

Can you describe your bug?

If I try to run select * query on a table that contains time ranges values, I get an error stating: "pyo3_runtime.PanicException: not implemented: tsrange"

What are the steps to reproduce the behavior?

  1. On a table with utc range columns, try running:

query_1 = "select * from table_name"
df1 = cx.read_sql(conn=conn_string, query=query_1, return_type="pandas")

Error: thread '' panicked at 'not implemented: tsrange', /Users/runner/work/connector-x/connector-x/connectorx/src/sources/postgres/typesystem.rs:100:22

pyo3_runtime.PanicException: not implemented: tsrange

Database setup if the error only happens on specific data or data type

problematic column data type: tsrange

Example query / code
query_1 = "select * from table_name"`
df1 = cx.read_sql(conn=conn_string, query=query_1, return_type="pandas")

What is the error?

thread '' panicked at 'not implemented: tsrange', /Users/runner/work/connector-x/connector-x/connectorx/src/sources/postgres/typesystem.rs:100:22

pyo3_runtime.PanicException: not implemented: tsrange

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions