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

   Hi! I was thinking about the possibility of a user wanting to rename a 
label, because there's a 
[page](https://neo4j.com/docs/apoc/current/graph-refactoring/rename-label-type-property/#rename-node-labels)
 in Neo4j's documentation dedicated to that. I tried just renaming the tables 
in Postgres, but I'm not sure if that's the correct way or if this may cause 
any errors. Here's what I've done:
   
   ```sql
   -- Create the graph.
   SELECT * FROM create_graph('PeopleGraph');
   NOTICE:  graph "PeopleGraph" has been created
    create_graph 
   --------------
    
   (1 row)
   
   -- Create a "People" node label.
   SELECT * FROM create_vlabel('PeopleGraph', 'People');
   NOTICE:  VLabel "People" has been created
    create_vlabel 
   ---------------
    
   (1 row)
   
   -- Alter the "People" label to "Actors".
   ALTER TABLE "PeopleGraph"."People" RENAME TO "Actors";
   ALTER TABLE
   
   SELECT * FROM "PeopleGraph"."Actors";
    id | properties 
   ----+------------
   (0 rows)
   
   ALTER TABLE "PeopleGraph"."People_id_seq" RENAME TO "Actors_id_seq";
   ALTER TABLE
   
   SELECT * FROM "PeopleGraph"."Actors_id_seq" ;
    last_value | log_cnt | is_called 
   ------------+---------+-----------
             1 |       0 | f
   (1 row)
   
   ```
   
   Is there another way to do that in AGE? I was also thinking about creating a 
function just for that using SPI, but it would probably lack performance, and 
queries such as the one that is shown in Neo4j wouldn't be possible just with 
SPI, I guess. If this is something that would be interesting to add to AGE, 
which structures and/or functions should I study to create a function to rename 
labels?


-- 
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-unsubscr...@age.apache.org.apache.org

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

Reply via email to