age icon indicating copy to clipboard operation
age copied to clipboard

Can not remove the label on a node

Open lloydsun opened this issue 3 years ago • 4 comments

Describe the bug I have a label "Game" on a node, I wanna change it to "game", but I tried REMOVE, I got an error:

syntax error at or near ":"

How are you accessing AGE (Command line, driver, etc.)? nodejs driver

I am using the official docker :latest

What data setup do we need to do?

...
SELECT
    *
FROM
    cypher('vg-graph', $$
        CREATE (g:Game {name: "Front Mission", uid: "Pt6DmC8jnzDy", body: "some text"})
    $$) as (n agtype);
...

What is the necessary configuration info needed?

  • no

What is the command that caused the error?

SET search_path TO ag_catalog;

SELECT
    *
FROM
    cypher('vg-graph', $$
        MATCH (n {uid:"Pt6DmC8jnzDy"})
        REMOVE n:Game
        RETURN n
    $$) as (n agtype);
ERROR:  syntax error at or near ":"

Expected behavior Remove the label

Environment (please complete the following information):

  • AGE 1.1.0
  • PostgreSQL 11.16 (Debian 11.16-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit

Additional context no.

lloydsun avatar Nov 21 '22 15:11 lloydsun

Currently, the REMOVE command cannot remove labels. Unlike Neo4j, AGE only supports 1 label name for any vertex or edge. So, removing a label would mean removing the vertex or edge.

Note to team: This may be something where we should consider removing a label name and setting it to the default label.

jrgemignani avatar Nov 22 '22 16:11 jrgemignani

Oh, I see. Thank you for the explanation! Keep up the GREAT work :)

lloydsun avatar Nov 22 '22 18:11 lloydsun

@jrgemignani - There's a lot of dormant issues that cause concern for new adopters (like me). Highly advise pruning or including a bot to do so.

rsoury avatar Jul 24 '24 15:07 rsoury

@rsoury We already have a bot (relatively new) doing just that, but we have to be fair to issue creators by giving them a reasonable amount of time to respond or close the ticket themselves. It is preferable that the issue creator closes their issue.

jrgemignani avatar Jul 24 '24 19:07 jrgemignani