connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

Support for Postgres sql_identifier type

Open usundare opened this issue 2 years ago • 0 comments

Querying the columns with type of sql-indentifier from postgres information_schema fails with PanicException: not implemented: name. Example Query: select column_name from information_schema.columns

Pasted the stack trace below.

File "..\.venv\lib\site-packages\polars\io\database.py", line 93, in read_database
    return _read_sql_connectorx(
  File "..\.venv\lib\site-packages\polars\io\database.py", line 124, in _read_sql_connectorx
    tbl = cx.read_sql(
  File "..\.venv\lib\site-packages\connectorx\__init__.py", line 257, in read_sql
    result = _read_sql(
pyo3_runtime.PanicException: not implemented: name

Will this be fixed by fix # 504 [Issue #501] that has been merged into the main branch? If so, when can we expect this fix to be released? Or do I need to open a new feature request for support of sql-indentifier?

I have a work around of casting to text but the work around does not work when running select * from information_schema.columns

usundare avatar Jul 26 '23 12:07 usundare