如何在AgensGraph上删除“GRAPH”?

我试图放下图表 . 删除图形时发生错误 .

# drop graph graph;
ERROR:  cannot drop graph graph because other objects depend on it
DETAIL:  sequence graph.ag_label_seq depends on schema graph
label ag_vertex depends on schema graph
label ag_edge depends on schema graph
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

如何删除“GRAPH”?

回答(1)

2 years ago

删除图形时,必须先删除所有数据和模式 .

为方便起见,可以使用可选的“CASCADE”子句 .

# drop graph graph cascade;
NOTICE:  drop cascades to 3 other objects
DETAIL:  drop cascades to sequence graph.ag_label_seq
drop cascades to label ag_vertex
drop cascades to label ag_edge
DROP GRAPH