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

ALTER TABLE ADD COLUMN with constraints not supported yet #1968

Open
cevin opened this issue Aug 3, 2019 · 2 comments
Open

ALTER TABLE ADD COLUMN with constraints not supported yet #1968

cevin opened this issue Aug 3, 2019 · 2 comments
Labels
area/ysql Yugabyte SQL (YSQL) community/request Issues created by external users kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue

Comments

@cevin
Copy link

cevin commented Aug 3, 2019

Jira Link: DB-2356

ERROR:  ALTER TABLE ADD COLUMN with constraints not supported yet
LINE 1: ALTER TABLE "public"."ww" ADD COLUMN "ti" int8 DEFAULT NULL;
                                  ^
HINT:  See https://github.com/YugaByte/yugabyte-db/issues/1124.
Click '+' on the description to raise its priority

All changes were reverted (DDL statements can't be reverted).

if... very afraid to use in a production environment

success:
alter table {table} add column {name} {type}

fail:
.. add constraints

@yugabyte-ci yugabyte-ci added the community/request Issues created by external users label Aug 3, 2019
@ndeodhar
Copy link
Contributor

ndeodhar commented Aug 3, 2019

Hi @cevin, we are actively working on enabling various ALTER TABLE commands and this is one of them. It should be available in the next 3-4 weeks.
Please note that YSQL is still in beta and we will be releasing a GA version soon in September.

@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label Aug 3, 2019
@cevin cevin closed this as completed Aug 9, 2019
@kmuthukk kmuthukk reopened this Aug 9, 2019
@kmuthukk
Copy link
Collaborator

kmuthukk commented Aug 9, 2019

We can keep the issue open here @cevin to track this specific request (since #1124 is a little broader).

@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 9, 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 Oct 5, 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) community/request Issues created by external users kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

5 participants