You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2021/04/28 01:37:43 UTC

[GitHub] [incubator-age] kysmou opened a new issue #57: First cypher execution error after alter database set search_path statement

kysmou opened a new issue #57:
URL: https://github.com/apache/incubator-age/issues/57


   In order to connect to the database, the following syntax was executed to execute the cypher syntax by default.
   
   alter database testdb set search_path to ag_catalog, "$user", public;
   
   After that, if you access the database and execute the cypher query, the following error occurs.
   
   1. alter database testdb set search_path to ag_catalog, "$user", public;
   2. \q
   3. psql testdb -p 5400
   4. 
   testdb=# SELECT *
   testdb-# FROM cypher('graph_name', $$
   testdb$# match(a:Person)
   testdb$# RETURN a
   testdb$# $$) as (a agtype);
   ERROR:  unhandled cypher(cstring) function call
   
   5. try again -> normal execute
   testdb=# SELECT *
   testdb-# FROM cypher('graph_name', $$
   testdb$# match(a:Person)
   testdb$# RETURN a
   testdb$# $$) as (a agtype);
                                                     a                                                  
   -----------------------------------------------------------------------------------------------------
    {"id": 844424930131970, "label": "Person", "properties": {"name": "Andres"}}::vertex
    {"id": 844424930131971, "label": "Person", "properties": {"name": "John"}}::vertex
    {"id": 844424930131973, "label": "Person", "properties": {}}::vertex
    {"id": 844424930131974, "label": "Person", "properties": {}}::vertex
    {"id": 844424930131972, "label": "Person", "properties": {"a": "c", "id": 1, "title": "1"}}::vertex
   (5 rows)
   
   Is there a problem or am I missing something?


-- 
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:
users@infra.apache.org

[GitHub] [incubator-age] pdpotter commented on issue #57: First cypher execution error after alter database set search_path statement

Posted by GitBox <gi...@apache.org>.
pdpotter commented on issue #57:
URL: https://github.com/apache/incubator-age/issues/57#issuecomment-828706717


   Did you execute `load 'age';` before the first cypher query (see #41)?


-- 
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:
users@infra.apache.org

[GitHub] [incubator-age] kysmou commented on issue #57: First cypher execution error after alter database set search_path statement

Posted by GitBox <gi...@apache.org>.
kysmou commented on issue #57:
URL: https://github.com/apache/incubator-age/issues/57#issuecomment-829042378


   @pdpotter 
   Thank you for your teaching. It's solved.
   It is inconvenient to execute the load age statement every time cypher is executed.
   Is there any method to execute cypher normally in first access without executing "load 'age'";


-- 
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:
users@infra.apache.org

[GitHub] [incubator-age] kysmou closed issue #57: First cypher execution error after alter database set search_path statement

Posted by GitBox <gi...@apache.org>.
kysmou closed issue #57:
URL: https://github.com/apache/incubator-age/issues/57


   


-- 
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:
users@infra.apache.org

[GitHub] [incubator-age] joefagan commented on issue #57: First cypher execution error after alter database set search_path statement

Posted by GitBox <gi...@apache.org>.
joefagan commented on issue #57:
URL: https://github.com/apache/incubator-age/issues/57#issuecomment-989019760


   @pdpotter to automatically load 'age' see issue #91 


-- 
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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-age] jrgemignani commented on issue #57: First cypher execution error after alter database set search_path statement

Posted by GitBox <gi...@apache.org>.
jrgemignani commented on issue #57:
URL: https://github.com/apache/incubator-age/issues/57#issuecomment-829382087


   You only need to execute the load once, at the beginning of a session. 


-- 
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:
users@infra.apache.org