citus
citus copied to clipboard
alter_distributed_table may change dependent materialized views' options
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.
also indexes on mat views
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.