pdpotter opened a new issue #33: URL: https://github.com/apache/incubator-age/issues/33
I installed the Apache AGE PostgreSQL extensio on Debian Buster using the instructions on https://age.apache.org/ (under Documentation -> Installing AGE). I was able to `CREATE EXTENSION age;`, `LOAD 'age';` and `SET search_path = ag_catalog, "$user", public;` as a superuser and subsequently create a graph and execute cypher queries. Unfortunately, I was unable to execute `LOAD 'age';` as non-superuser. I tried moving `/usr/lib/postgresql/11/lib/age.so` to `/usr/lib/postgresql/11/lib/plugins/age.so` (as mentioned in https://www.postgresql.org/docs/11/sql-load.html) and was then able to execute `LOAD 'age';`, but then I got following errors when trying to use AGE functions create_graph and cypher: ``` => SELECT create_graph('g'); ERROR: function create_graph(unknown) does not exist LINE 1: SELECT create_graph('g'); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ``` ``` => SELECT * from cypher('g', $$ CREATE (a:Person {name: 'Tom'}) $$) as (a agtype); ERROR: function cypher(unknown, unknown) does not exist LINE 1: SELECT * from cypher('g', $$ CREATE (a:Person {name: 'Tom'})... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ``` Is it currently only possible to execute AGE functions as a superuser, or do I need to do additional configuration in order to make them available to non-superusers? ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
