Query exec error: syntax error at or near "Node"

[Cylkal]

tables:

CREATE TABLE IF NOT EXISTS Node (
              id INTEGER PRIMARY KEY,
              func_name TEXT,
              pos TEXT
          )
  ;
CREATE TABLE IF NOT EXISTS Edge (
              caller_id INTEGER REFERENCES Node(id),
              callee_id INTEGER REFERENCES Node(id)
          );

graph table:

CREATE PROPERTY GRAPH cg
      VERTEX TABLES (Node)
      EDGE TABLES (Edge SOURCE KEY (caller_id) REFERENCES Node(id)
      DESTINATION KEY (callee_id) REFERENCES Node(id)
      );

query err:

FROM GRAPH_TABLE (cg MATCH (caller:Node)-[e:edge]->(callee:Node) COLUMNS (callee.func_name));
Parser Error:
syntax error at or near "Node"

LINE 1: FROM GRAPH_TABLE (cg MATCH (caller:Node)-[e:edge]->(callee:Node) COLUMNS (callee.func_name));
                                           ^

What's wrong?

[Dtenwolde]

Hi there,

I think this is given a vague syntax error because Node (and Edge) are unreserved keywords and can not be used inside a PGQ match statement. Changing the table names to Nodes and Edges resolves the problem.

Hope this helps :)

[Cylkal]

Thanks a lot, it works. 👍