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

Cannot change owner of continuous aggregate #2414

Closed
erimatnor opened this issue Sep 18, 2020 · 3 comments · Fixed by #2428
Closed

Cannot change owner of continuous aggregate #2414

erimatnor opened this issue Sep 18, 2020 · 3 comments · Fixed by #2428
Assignees
@mkindahl
Labels
bug continuous_aggregate
Milestone
2.0.0

Comments

@erimatnor
Copy link
Contributor

Trying to change the owner of a continuous aggregate generates an error.

postgres=# ALTER MATERIALIZED VIEW foo_1day OWNER TO foo;
ERROR:  cannot alter only SET options of a continuous aggregate
@erimatnor erimatnor added this to the 2.0.0 milestone Sep 18, 2020
@mkindahl mkindahl self-assigned this Sep 21, 2020
@erimatnor
Copy link
Contributor Author

erimatnor commented Sep 22, 2020 •
edited

This is actually a duplicate of #1277. @mkindahl can you merge the issue or at least make sure the other issue is updated as part of fixing this?

@erimatnor
Copy link
Contributor Author

@mkindahl also note that we need to test the behavior of "refresh-on-drop" when owner of cagg is different from source hypertable.

mkindahl added a commit to mkindahl/timescaledb that referenced this issue Sep 22, 2020
@mkindahl
Allow owner change of continuous aggregate
0f3697f 
Implements support for changing the owner of the continuous aggregate.
This will change the owner of both the materialized hypertable and the
user view.

Fixes timescale#2414
Fixes timescale#1277
@mkindahl mkindahl mentioned this issue Sep 22, 2020
Merged
mkindahl added a commit to mkindahl/timescaledb that referenced this issue Sep 22, 2020
@mkindahl
Allow owner change of continuous aggregate
e4199a8 
Implements support for changing the owner of the continuous aggregate.
This will change the owner of both the materialized hypertable and the
user view.

Fixes timescale#2414
Fixes timescale#1277
@mkindahl
Copy link
Contributor

@mkindahl also note that we need to test the behavior of "refresh-on-drop" when owner of cagg is different from source hypertable.

This should be handled in #2413 rather than this issue.

mkindahl added a commit to mkindahl/timescaledb that referenced this issue Sep 23, 2020
@mkindahl
Allow owner change of continuous aggregate
ae3e434 
Implements support for changing the owner of the continuous aggregate.
This will change the owner of the materialized hypertable, the
user view, the partial view, and the direct view.

Fixes timescale#2414
Fixes timescale#1277
mkindahl added a commit to mkindahl/timescaledb that referenced this issue Sep 23, 2020
@mkindahl
Allow owner change of continuous aggregate
2119cc1 
Implements support for changing the owner of the continuous aggregate.
This will change the owner of the materialized hypertable, the
user view, the partial view, and the direct view.

Fixes timescale#2414
Fixes timescale#1277
mkindahl added a commit that referenced this issue Sep 23, 2020
@mkindahl
Allow owner change of continuous aggregate
6aae14c 
Implements support for changing the owner of the continuous aggregate.
This will change the owner of the materialized hypertable, the
user view, the partial view, and the direct view.

Fixes #2414
Fixes #1277
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mkindahl mkindahl

Labels
bug continuous_aggregate
Projects
None yet
Milestone
2.0.0
Development

Successfully merging a pull request may close this issue.

Allow owner change of continuous aggregate mkindahl/timescaledb
2 participants
@erimatnor @mkindahl