search

GlareDB / glaredb

GlareDB: An analytics DBMS for distributed data
https://glaredb.com
GNU Affero General Public License v3.0
634 stars 36 forks source link

unable to connect via adbc postgres driver (no pg_catalog.pg_type) #2207

Open universalmind303 opened 9 months ago

universalmind303 commented 9 months ago

Description

import adbc_driver_postgresql.dbapi

uri = "postgresql://localhost:6543"

with adbc_driver_postgresql.dbapi.connect(uri) as conn:
  cursor = conn.cursor()
  cursor.execute("select 1")
  print(cursor.fetchone())
  cursor.close()

  adbc_driver_manager.OperationalError: IO: [libpq] Failed to build type mapping table: ERROR:  Error during planning: Unable to fetch table provider for 'pg_catalog.pg_type': failed to resolve: failed to find table: pg_catalog.pg_type

same root cause as https://github.com/GlareDB/glaredb/issues/1450 and https://github.com/GlareDB/glaredb/issues/1445

scsmithr commented 9 months ago

https://www.postgresql.org/docs/current/catalog-pg-type.html#CATALOG-TYPCATEGORY-TABLE