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] Support ALTER TABLE alter column sequence/identity #2226

Closed
ndeodhar opened this issue Sep 5, 2019 · 0 comments
Closed

[YSQL] Support ALTER TABLE alter column sequence/identity #2226

ndeodhar opened this issue Sep 5, 2019 · 0 comments
Assignees
@Zhongweizhao
Labels
area/ysql Yugabyte SQL (YSQL)
Milestone
v2.0

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented Sep 5, 2019

Support alter table alter column variations to set/drop identity:
ALTER TABLE ALTER COLUMN SET GENERATED/sequence_option
ALTER TABLE ALTER COLUMN DROP identity
@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label Sep 5, 2019
@ndeodhar ndeodhar added this to the v2.0 milestone Sep 5, 2019
Zhongweizhao pushed a commit that referenced this issue Sep 16, 2019
[YSQL]: #2226 Allow ALTER COLUMN add/set/drop identity.
9e57e45 
Summary:
ALTER [ COLUMN ] column_name ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( sequence_options ) ]
ALTER [ COLUMN ] column_name { SET GENERATED { ALWAYS | BY DEFAULT } | SET sequence_option | RESTART [ [ WITH ] restart ] } [...]
ALTER [ COLUMN ] column_name DROP IDENTITY [ IF EXISTS ]

Test Plan:
./yb_build.sh --java-test org.yb.pgsql.TestPgRegressFeature
./yb_build.sh --java-test org.yb.pgsql.TestPgRegressPgMisc

Reviewers: neha

Reviewed By: neha

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D7171
Zhongweizhao pushed a commit that referenced this issue Sep 20, 2019
[YSQL]: #2226 Added a comment to ALTER COLUMN add/set/drop identity t…
4b0ac31 
…est.

Summary: Add missing comments.

Test Plan: ./yb_build.sh --java-test org.yb.pgsql.TestPgRegressPgMiscIndependent

Reviewers: neha

Reviewed By: neha

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D7222
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Zhongweizhao Zhongweizhao

Labels
area/ysql Yugabyte SQL (YSQL)
Projects
None yet
Milestone
v2.0
Development

No branches or pull requests
2 participants
@ndeodhar @Zhongweizhao