AdbcDriverPostgresqlInit undefined in Python Lib 0.7.0

[fbalicchia]

I'm trying to use the adbc library in Python 3.11 to interact with a PostgreSQL database, but I'm encountering an error related to the adbc_driver_postgresql module. The error message provided suggests that there's an issue with the PostgreSQL driver initialization.

adbc_driver_manager.InternalError: INTERNAL: dlsym(AdbcDriverPostgresqlInit) failed: /home/arrow-adbc/python/adbc_driver_postgresql/adbc_driver_postgresql/libadbc_driver_postgresql.so: undefined symbol: AdbcDriverPostgresqlInit

Snippet that I used to reproduce the problem is

import adbc_driver_sqlite.dbapi

with adbc_driver_sqlite.dbapi.connect() as conn:
    with conn.cursor() as cur:
        cur.execute("SELECT 1")
        print(cur.fetch_arrow_table())

In my env there are the following deps

adbc-driver-manager    0.7.0
adbc-driver-postgresql 0.7.0
numpy                  1.26.1
pip                    23.3
pyarrow                12.0.0
setuptools             68.0.0
wheel                  0.41.2

and I bootstrap postgresql with

$ docker run -it --rm \
    -e POSTGRES_PASSWORD=password \
    -e POSTGRES_DB=tempdb \
    -p 5432:5432 \
    postgres

Can you please suggest some actions to continue with my experiments?

[lidavidm]

How did you install everything? That path looks wrong, like it's trying to use a local install of ADBC, and not your wheel.

[fbalicchia]

Thanks @lidavidm . Yes, you are right my shell pointed to the local installation. Now it works