You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "cmucheru (via GitHub)" <gi...@apache.org> on 2023/10/15 17:50:36 UTC

[I] How do I add explicit type cast types? [age]

cmucheru opened a new issue, #1279:
URL: https://github.com/apache/age/issues/1279

   I am working with the age through the psql terminal. I am trying to create a graph but then I am getting an issue. 
   ```
   psql (14.9)
   Type "help" for help.
   
   postgres=# CREATE EXTENSION age;
   CREATE EXTENSION
   postgres=# LOAD 'age';
   LOAD
   postgres=# SELECT create_graph('new_graph');
   2023-10-15 20:18:02.928 EAT [15166] ERROR:  function create_graph(unknown) does not exist at character 8
   2023-10-15 20:18:02.928 EAT [15166] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
   2023-10-15 20:18:02.928 EAT [15166] STATEMENT:  SELECT create_graph('new_graph');
   ERROR:  function create_graph(unknown) does not exist
   LINE 1: SELECT create_graph('new_graph');
                  ^
   HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
   postgres=#  
   ```
   How do I add these explicit type casts?


-- 
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.apache.org

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

Re: [I] How do I add explicit type casts? [age]

Posted by "cmucheru (via GitHub)" <gi...@apache.org>.
cmucheru commented on issue #1279:
URL: https://github.com/apache/age/issues/1279#issuecomment-1763904572

   I have seen I have to add the `ag_catalog` to my `search_path`. Great  @CapnSpek 


-- 
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

Re: [I] How do I add explicit type casts? [age]

Posted by "CapnSpek (via GitHub)" <gi...@apache.org>.
CapnSpek commented on issue #1279:
URL: https://github.com/apache/age/issues/1279#issuecomment-1763534739

   Use either
   ```
   SELECT * FROM ag_catalog.create_graph('graph_name');
   ```
   
   Or
   ```
   SET search_path = ag_catalog, "$user", public;
   SELECT * FROM create_graph('graph_name');
   ```
   
   The issue is actually `No function matches the given name and argument types.` because AGE is not able to find the function like that.


-- 
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

Re: [I] How do I add explicit type casts? [age]

Posted by "cmucheru (via GitHub)" <gi...@apache.org>.
cmucheru closed issue #1279: How do I add explicit type casts?
URL: https://github.com/apache/age/issues/1279


-- 
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