markgomer opened a new issue, #1178:
URL: https://github.com/apache/age/issues/1178
**Describe the bug**
`SELECT drop_graph('graph_name')` is not deleting recently created graph.
**How are you accessing AGE (Command line, driver, etc.)?**
- psql interface, command line.
**What is the necessary configuration info needed?**
- Fresh install of PostgreSQL 15 and Apache AGE master, on Debian
stable-slim Docker image.
**What is the command that caused the error?**
```pgsql
psql (15.4)
Type "help" for help.
test=# CREATE EXTENSION age;
CREATE EXTENSION
test=# LOAD 'age';
SET search_path TO ag_catalog;
LOAD
SET
test=# SELECT * FROM ag_catalog.ag_graph;
graphid | name | namespace
---------+------+-----------
(0 rows)
```
```
test=# SELECT create_graph('agload');
NOTICE: graph "agload" has been created
create_graph
--------------
(1 row)
test=# SELECT drop_graph('agload');
2023-08-23 10:33:23.574 -03 [28787] ERROR: cannot drop schema agload
because other objects depend on it
2023-08-23 10:33:23.574 -03 [28787] DETAIL: table agload._ag_label_vertex
depends on schema agload
table agload._ag_label_edge depends on schema agload
2023-08-23 10:33:23.574 -03 [28787] HINT: Use DROP ... CASCADE to drop the
dependent objects too.
2023-08-23 10:33:23.574 -03 [28787] STATEMENT: SELECT drop_graph('agload');
ERROR: cannot drop schema agload because other objects depend on it
DETAIL: table agload._ag_label_vertex depends on schema agload
table agload._ag_label_edge depends on schema agload
HINT: Use DROP ... CASCADE to drop the dependent objects too.
test=#
```
**Expected behavior**
After `SELECT drop_graph('graph_name');` the graph should be dropped along
with all its vertexes and edges.
**Environment (please complete the following information):**
- AGE Version: 1.3.0
--
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]
