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.

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

[YSQL] Allow adding primary key to partitioned table using ALTER TABLE #10074

Open
sushantrmishra opened this issue Sep 22, 2021 · 0 comments
Open
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@sushantrmishra
Copy link

sushantrmishra commented Sep 22, 2021

Jira Link: DB-736
Currently adding primary key to partitioned table in YugabyteDB fails. This works fine in PostgreSQL.

CREATE TABLE orders2 (
order_id bigint NOT NULL,
order_date timestamp
) PARTITION BY RANGE (order_date) ;
ALTER TABLE orders2 ADD PRIMARY KEY (order_id,order_date);

ERROR: adding primary key to a partitioned table is not yet implemented

@sushantrmishra sushantrmishra added the area/ysql Yugabyte SQL (YSQL) label Sep 22, 2021
@sushantrmishra sushantrmishra changed the title [YSQL] Allow adding primary key to partitioned table [YSQL] Allow adding primary key to partitioned table using ALTER TABLE Sep 22, 2021
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Aug 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

2 participants