migra
migra copied to clipboard
MATERIALIZED VIEWs: "WITH NO DATA" setting is ignored
For materialized views originally created using command:
CREATE MATERIALIZED VIEW
...
WITH NO DATA
The WITH NO DATA part at the end is not retained by migra on the destination database. The setting is ignored, which leaves postgres to use the default of WITH DATA.
Some info on WITH [ NO ] DATA:
- https://www.postgresql.org/docs/current/sql-creatematerializedview.html