CC-Hsu opened a new issue, #839: URL: https://github.com/apache/age/issues/839
Hi, Team, Previously we try to use Apache AGE Python driver to access an AGE database. But we find that we can not run the driver successfully without a DB user with superuser privilege due to `LOAD age;` command. We know that in the prerequisite information one need to test the setup with `LOAD age;` command in the `psql`. https://github.com/apache/age/tree/master/drivers/python#check-age-loaded-on-your-postgresql And we also see the driver also execute `LOAD age;` first (I copy the corresponding code snippet below). https://github.com/apache/age/blob/master/drivers/python/age/age.py#L32 ```python def setUpAge(conn:ext.connection, graphName:str): with conn.cursor() as cursor: cursor.execute("LOAD 'age';") ``` Although the [`LOAD` command](https://www.postgresql.org/docs/current/sql-load.html) is superuser-restricted, it may be replaced by setting [`local_preload_libraries`](https://postgresqlco.nf/doc/en/param/local_preload_libraries/) GUC, so that `LOAD` command can be skipped and allow non-superuser DB roles to use Apache AGE objects. Is it possible to improve the python driver to also support non-superuser usage in this way? Best Regards. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
