How to drop "GRAPH" on AgensGraph?

Question

I tried to drop graph. An error occurred when dropping 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.

How to drop "GRAPH"?

probably, # drop graph graph cascade; ? – serges_newj Oct 12 '18 at 06:26 — serges_newj, Oct 12 '18 at 06:26

score 0 · Answer 1 · answered Oct 12 '18 at 06:49

When dropping graph, all data & schema must be drop before.

For convenience, optional "CASCADE" clause is usable.

# 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

How to drop "GRAPH" on AgensGraph?

1 Answers1