migra icon indicating copy to clipboard operation
migra copied to clipboard

MATERIALIZED VIEWs: "WITH NO DATA" setting is ignored

Open hi2u opened this issue 4 years ago • 0 comments

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

hi2u avatar Jun 04 '21 16:06 hi2u