CapnSpek commented on issue #1257:
URL: https://github.com/apache/age/issues/1257#issuecomment-1759431400
I have been unable to reproduce the bug,
Using JDBC I get
```
org.postgresql.util.PSQLException: ERROR: table "Man" is for label "Man"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:246)
at Sample.main(Sample.java:26)
```
On AGE I get
```
test=# DROP SCHEMA graph2;
2023-10-12 14:28:31.405 EEST [83618] ERROR: cannot drop schema graph2
because other objects depend on it
2023-10-12 14:28:31.405 EEST [83618] DETAIL: sequence graph2._label_id_seq
depends on schema graph2
table graph2._ag_label_vertex depends on schema graph2
table graph2._ag_label_edge depends on schema graph2
table graph2."Man" depends on schema graph2
2023-10-12 14:28:31.405 EEST [83618] HINT: Use DROP ... CASCADE to drop the
dependent objects too.
2023-10-12 14:28:31.405 EEST [83618] STATEMENT: DROP SCHEMA graph2;
ERROR: cannot drop schema graph2 because other objects depend on it
DETAIL: sequence graph2._label_id_seq depends on schema graph2
table graph2._ag_label_vertex depends on schema graph2
table graph2._ag_label_edge depends on schema graph2
table graph2."Man" depends on schema graph2
HINT: Use DROP ... CASCADE to drop the dependent objects too.
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."Man"
2023-10-12 14:28:49.040 EEST [83618] ERROR: table "Man" is for label "Man"
2023-10-12 14:28:49.040 EEST [83618] STATEMENT: DROP SCHEMA graph2 CASCADE;
ERROR: table "Man" is for label "Man"
```
Using PostgreSQL15.4 on Master branch AGE.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
