connectorx generate error when fetching values from columns with tsrange data type #429
Open
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?
- 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