jrgemignani commented on issue #33:
URL: https://github.com/apache/incubator-age/issues/33#issuecomment-791568123
Did you execute "set search_path TO ag_catalog;" in the session prior to
executing the "select create_graph('g');" command?
John
On Fri, Mar 5, 2021 at 6:45 AM Pieterjan De Potter <notificati...@github.com>
wrote:
> I installed the Apache AGE PostgreSQL extension 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?
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/incubator-age/issues/33>, or unsubscribe
>
<https://github.com/notifications/unsubscribe-auth/AALPO4HPZDNSX2PBE7AGPALTCDVBJANCNFSM4YVK2BHA>
> .
>
----------------------------------------------------------------
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
