jrgemignani commented on issue #33: URL: https://github.com/apache/incubator-age/issues/33#issuecomment-791744766
You need to do the following for said user, say *john* for said database, say *graphdb *- GRANT USAGE ON SCHEMA *ag_catalog *TO *john*; GRANT CREATE ON DATABASE *graphdb *TO *john*; You don't need to do a load, once the extension has been loaded. You just need to set the search path. John On Fri, Mar 5, 2021 at 12:56 PM Pieterjan De Potter < [email protected]> wrote: > Yes. See below for a more complete listing of the statements I executed > after logging in as a non-superuser, who is the owner of the database that > is being connected > > psql -U crdb -W -h 127.0.0.1 -p 5433 crdb > Password: > psql (11.7 (Debian 11.7-0+deb10u1), server 11.10 (Debian 11.10-0+deb10u1)) > SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) > Type "help" for help. > > crdb=> load '$libdir/plugins/age.so'; > LOAD > crdb=> SET search_path = ag_catalog, "$user", public; > SET > crdb=> 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. > > — > You are receiving this because you commented. > Reply to this email directly, view it on GitHub > <https://github.com/apache/incubator-age/issues/33#issuecomment-791682832>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AALPO4CLV23GJGG6DOXP5IDTCFAOHANCNFSM4YVK2BHA> > . > ---------------------------------------------------------------- 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: [email protected]
