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

Cannot read from pg_catalog #475

Open
mcrumiller opened this issue Mar 26, 2023 · 1 comment
Open

Cannot read from pg_catalog #475

mcrumiller opened this issue Mar 26, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@mcrumiller
Copy link

What are you using?

Python 3.9, cx 0.3.1, PostgrSQL (Greenplum)

Can you describe your bug?

Cannot query the pg_catalog system table for database information.

What are the steps to reproduce the behavior?

import connectorx as cx

conn = f"postgresql://{user}:{pw}1@{server}:{port}/{database}"

# this query errors in cx, not in pandas or via other SQL clients
result = cx.read_sql(conn.conn, "SELECT * FROM pg_catalog.pg_tables")
thread '<unnamed>' panicked at 'not implemented: name', D:\a\connector-x\connector-x\connectorx\src\sources\postgres\typesystem.rs:100:22
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
Traceback (most recent call last):
  df = cx.read_sql(conn.conn, "SELECT * FROM pg_catalog.pg_tables")
  File "C:\Projects\python-toolbox\.venv_toolbox\lib\site-packages\connectorx\__init__.py", line 224, in read_sql
    result = _read_sql(
pyo3_runtime.PanicException: not implemented: name
@mcrumiller mcrumiller added the bug Something isn't working label Mar 26, 2023
@Jordan-M-Young
Copy link
Contributor

Hi @mcrumiller I think this PR might solve your issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants