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] ALTER Materialized View #10512

Closed
fizaaluthra opened this issue Nov 5, 2021 · 0 comments
Closed

[YSQL] ALTER Materialized View #10512

fizaaluthra opened this issue Nov 5, 2021 · 0 comments
Assignees
@rachelphan1508
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@fizaaluthra
Copy link
Member

fizaaluthra commented Nov 5, 2021 •
edited by yugabyte-ci
Loading

Jira Link: DB-899

Description

Issue for tracking ALTER MATERIALIZED VIEW.
@fizaaluthra fizaaluthra added the area/ysql Yugabyte SQL (YSQL) label Nov 5, 2021
@fizaaluthra fizaaluthra mentioned this issue Nov 5, 2021
Closed
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@tverona1 tverona1 changed the title [YSQL] ALTER Materialized View [YSQL] ALTER Materialized View Sep 7, 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 Sep 13, 2022
rachelphan1508 pushed a commit that referenced this issue Sep 29, 2022
[#10512] YSQL: Adding support for ALTER MATERIALIZED VIEW
ec9b36b 
Summary:
- Alter a MV’s owner:
     `ALTER MATERIALIZED VIEW OWNER TO { new_owner | CURRENT_USER | SESSION_USER }`

- Rename MV:
     `ALTER MATERIALIZED VIEW [ IF EXISTS ] name RENAME TO new_name`

- Rename MV’s column:
     `ALTER MATERIALIZED VIEW [ IF EXISTS ] name RENAME [ COLUMN ] column_name TO new_column_name`

Test Plan: `TestPgRegressMatview`

Reviewers: fizaa, plee

Reviewed By: fizaa, plee

Subscribers: jenkins-bot, yql

Differential Revision: https://phabricator.dev.yugabyte.com/D19508
@yugabyte-ci yugabyte-ci moved this to Done in YQL-beta Sep 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rachelphan1508 rachelphan1508

Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
YQL-beta
Status: Done
Milestone
No milestone
Development

No branches or pull requests
4 participants
@sushantrmishra @yugabyte-ci @fizaaluthra @rachelphan1508