[GitHub] [age] imranzaheer612 commented on issue #426: Rollbacking transactions in AGE not supporting.

[GitBox <gi...@apache.org>]

imranzaheer612 commented on issue #426:
URL: https://github.com/apache/age/issues/426#issuecomment-1365332787

   But it worked in my case.
   
   ```bash
   demo=# BEGIN; SELECT * from cypher('graph_name', $$
   MATCH (V) detach delete (V) $$) as (a agtype);
   BEGIN
    a 
   ---
   (0 rows)
   
   demo=# SELECT * from cypher('graph_name', $$
   MATCH (V) RETURN (V) $$) as (a agtype);
    a 
   ---
   (0 rows)
   
   demo=# rollback;
   ROLLBACK
   demo=# SELECT * from cypher('graph_name', $$
   MATCH (V) RETURN (V) $$) as (a agtype);
                                     a                                  
   ---------------------------------------------------------------------
    {"id": 281474976710657, "label": "", "properties": {}}::vertex
    {"id": 844424930131969, "label": "label", "properties": {}}::vertex
    {"id": 844424930131970, "label": "label", "properties": {}}::vertex
   (3 rows)
   
   demo=# 
   
   ```
   I added some nodes to the graph. Deleted them. Rolled back successfully. Let me try deleting nodes having relationships.


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