Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
frozenspider opened this issue Jul 13, 2022 · 1 comment
Open

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

frozenspider opened this issue Jul 13, 2022 · 1 comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
YSQL DDL improvements

Comments

@frozenspider
Copy link
Contributor

frozenspider commented Jul 13, 2022 •
edited by yugabyte-ci

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.
@frozenspider frozenspider added kind/enhancement This is an enhancement of an existing feature area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Jul 13, 2022
@frozenspider frozenspider added this to To do in DDL improvements via automation Jul 13, 2022
@frozenspider frozenspider added this to Backlog in YSQL via automation Jul 13, 2022
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jul 13, 2022
@frozenspider frozenspider mentioned this issue Jul 13, 2022
Open
@d-uspenskiy d-uspenskiy mentioned this issue Jul 13, 2022
Closed
@yugabyte-ci yugabyte-ci removed the status/awaiting-triage Issue awaiting triage label Jul 27, 2022
@frozenspider frozenspider mentioned this issue Jul 29, 2022
Closed
@yugabyte-ci yugabyte-ci changed the title [YSQL] Make chaning primary key an online operation [YSQL] Make changing primary key an online operation Sep 18, 2022
@fire
Copy link

fire commented Jul 19, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
DDL improvements
  
To do
YSQL
  
Backlog
Milestone
No milestone
Development

No branches or pull requests
3 participants
@fire @frozenspider @yugabyte-ci