deem0n opened a new issue #132: URL: https://github.com/apache/incubator-age/issues/132
There is no upgrade scripts, unfortunately. To upgrade I need to drop extension and all dependent data. ``` mi=# select * from pg_available_extensions where name = 'age'; ┌──────┬─────────────────┬───────────────────┬────────────────────────┐ │ name │ default_version │ installed_version │ comment │ ├──────┼─────────────────┼───────────────────┼────────────────────────┤ │ age │ 0.6.0 │ 0.5.0 │ AGE database extension │ └──────┴─────────────────┴───────────────────┴────────────────────────┘ (1 row) mi=# alter extension age update to '0.6.0'; ERROR: extension "age" has no update path from version "0.5.0" to version "0.6.0" mi=# drop extension age; ERROR: cannot drop extension age because other objects depend on it DETAIL: column id of table age._ag_label_vertex depends on type ag_catalog.graphid column id of table age._ag_label_edge depends on type ag_catalog.graphid column start_id of table age._ag_label_edge depends on type ag_catalog.graphid column end_id of table age._ag_label_edge depends on type ag_catalog.graphid column properties of table age._ag_label_vertex depends on type ag_catalog.agtype column properties of table age._ag_label_edge depends on type ag_catalog.agtype HINT: Use DROP ... CASCADE to drop the dependent objects too. mi=# drop extension age cascade; NOTICE: drop cascades to 6 other objects DETAIL: drop cascades to column id of table age._ag_label_vertex drop cascades to column id of table age._ag_label_edge drop cascades to column start_id of table age._ag_label_edge drop cascades to column end_id of table age._ag_label_edge drop cascades to column properties of table age._ag_label_vertex drop cascades to column properties of table age._ag_label_edge DROP EXTENSION mi=# create extension age; CREATE EXTENSION mi=# select * from pg_available_extensions where name = 'age'; ┌──────┬─────────────────┬───────────────────┬────────────────────────┐ │ name │ default_version │ installed_version │ comment │ ├──────┼─────────────────┼───────────────────┼────────────────────────┤ │ age │ 0.6.0 │ 0.6.0 │ AGE database extension │ └──────┴─────────────────┴───────────────────┴────────────────────────┘ (1 row) ``` -- 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
