citus icon indicating copy to clipboard operation
citus copied to clipboard

alter_distributed_table may change dependent materialized views' options

Open velioglu opened this issue 3 years ago • 2 comments

While altering a distributed table with alter_distributed_table, Citus recreates materialized views depending on that table. Though,

  • Aliases
  • Storage parameters
  • Tablespace
  • WITH [NO] DATA

options for materialized views are not handled properly while recreating them. Parser functions should be added and CreateMaterializedViewDDLCommand should be updated accordingly to handle them.

velioglu avatar May 24 '22 12:05 velioglu

also indexes on mat views

onderkalaci avatar Jul 04 '22 13:07 onderkalaci

I'm kind of wondering whether we should try to preserve the shell table in undistribute/alter operations, to be able to keep the materialized views.

marcocitus avatar Jul 09 '22 10:07 marcocitus