I'm trying to use langchain to query RisingWave with natural language, but I'm encountering an issue with table reflection, which requires access to the pg_get_indexdef function. This function is not currently supported in RisingWave. Is there any plan to include this feature in the roadmap?
Georg Boegerl
Asked on Dec 03, 2023
It seems that you are using the postgres:// URL scheme, which might be causing the issue with pg_get_indexdef. RisingWave provides a different library, sqlalchemy-risingwave, which should be installed via pip install sqlalchemy-risingwave. Make sure to use the URL scheme risingwave+psycopg2:// for the connection. This should resolve the issue you're facing. Additionally, I will update the sqlalchemy guide in our documentation to reflect this information.
