Implement Graph binary-upgrade - Githubissues

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL

http://www.agensgraph.org

Other

1.32k stars 146 forks source link

Implement Graph binary-upgrade #571

Closed emotionbug closed 1 year ago

emotionbug commented 2 years ago

Previously, Graph data did not support binary-upgrade. Also, in regular dumps, there were mixed up with giddy codes. This made the upgrade uncomfortable.

So, adds a small unit of graph DDL and GUC for upgrade and change it to use.

Syntax

CREATE ONLY (V|E)LABEL
(ID)
- DO NOT USE GRAPH SEQUENCE
- DO NOT MAKE CONSTRAINTS
- DO NOT GENERATE NEW ID
CREATE BASE GRAPH
- DO NOT MAKE BASE (V|E)LABEL
- DO NOT MAKE SEQUENCE

GUC

cypher_allow_unsafe_ddl

Functions

binary_upgrade_set_next_ag_graph_oid ( OID )
binary_upgrade_set_next_ag_label_oid ( OID )

emotionbug commented 2 years ago

It has already been applied to the main branch. ( https://github.com/bitnine-oss/agensgraph/commit/42aab446ca7a761f5cf9d99b67f612d629d79b74 ) and, will be cherry-picking in AG2.5, AG2.12.