[YSQL] Make changing primary key an online operation

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

https://www.yugabyte.com

Other

8.98k stars 1.07k forks source link

[YSQL] Make changing primary key an online operation #13274

Open frozenspider opened 2 years ago

frozenspider commented 2 years ago

Jira Link: DB-2917

Description

Two variants of ALTER TABLE changing PRIMARY KEY - ADD (#1104) and DROP (#8735) - are currently implemented to help database setup by some tools (ORMs, Keycloak, etc.) do not honor concurrent DMLs which may lead to data loss.

This needs to be changed to either become an online operation, or lock an entire table for the ALTER time.

fire commented 1 year ago

How can I check the position of this on the roadmap?