CapnSpek commented on issue #1257:
URL: https://github.com/apache/age/issues/1257#issuecomment-1763396324
So far, I tried setting up the database through the commands mentioned in
the issue using both JDBC and Postgres.
Other than that, I tried
Manually creating a vertex with a label for 1 graph, creating vertex using
the same label for other graph, then `DROP SCHEMA graph2 CASCADE;`
That also does not crash the database but only gives an error.
```
test=# SELECT * FROM ag_catalog.create_graph('graph1');
NOTICE: graph "graph1" has been created
create_graph
--------------
```
```
test=# SELECT * FROM ag_catalog.create_graph('graph2');
NOTICE: graph "graph2" has been created
create_graph
--------------
(1 row)
```
```
test=# SELECT * FROM cypher('graph1', $$ CREATE (x:Person {name:'X'}) RETURN
x $$) AS (x agtype);
x
--------------------------------------------------------------------------------
-
{"id": 844424930131969, "label": "Person", "properties": {"name":
"X"}}::vertex
(1 row)
```
```
test=# SELECT * FROM cypher('graph2', $$ CREATE (x:Person {name:'Y'}) RETURN
x $$) AS (x agtype);
x
--------------------------------------------------------------------------------
-
{"id": 844424930131969, "label": "Person", "properties": {"name":
"Y"}}::vertex
(1 row)
```
```
test=# DROP SCHEMA graph2 CASCADE;
NOTICE: drop cascades to 4 other objects
DETAIL: drop cascades to sequence graph2._label_id_seq
drop cascades to table graph2._ag_label_vertex
drop cascades to table graph2._ag_label_edge
drop cascades to table graph2."Person"
2023-10-15 16:51:24.432 EEST [160811] ERROR: table "Person" is for label
"Person"
2023-10-15 16:51:24.432 EEST [160811] STATEMENT: DROP SCHEMA graph2 CASCADE;
ERROR: table "Person" is for label "Person"
```
--
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
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
