Warn the user on changing the definition of Materialized View about the loss of data and its dependent objects. Fixes #4396
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=d98e86d3df9912891080e2b946083c051c5bb654 Author: Rahul Shirsat <rahul.shir...@enterprisedb.com> Modified Files -------------- docs/en_US/materialized_view_dialog.rst | 4 +- docs/en_US/release_notes_4_16.rst | 33 +-- .../databases/schemas/views/static/js/mview.js | 18 +- .../templates/mviews/pg/9.4_plus/sql/update.sql | 16 +- .../templates/mviews/ppas/9.3_plus/sql/update.sql | 12 +- .../pg/9.4_plus/alter_mview_add_fillfactor.sql | 5 +- .../9.4_plus/alter_mview_add_fillfactor_msql.sql | 2 +- .../9.4_plus/alter_mview_add_table_parameter.sql | 5 +- .../tests/pg/9.4_plus/alter_mview_definition.sql | 5 +- .../pg/9.4_plus/alter_mview_definition_msql.sql | 4 + .../alter_mview_remove_table_parameter.sql | 5 +- .../tests/pg/9.4_plus/alter_view_add_some_priv.sql | 2 +- .../pg/9.4_plus/alter_view_add_some_priv_msql.sql | 2 +- .../views/tests/pg/9.4_plus/test_mview.json | 2 +- .../schemas/views/tests/pg/9.4_plus/tests.json | 22 +- .../views/tests/ppas/11_plus/alter_mview.sql | 18 -- .../ppas/11_plus/alter_mview_add_fillfactor.sql | 16 -- .../11_plus/alter_mview_add_fillfactor_msql.sql | 6 - .../11_plus/alter_mview_add_table_parameter.sql | 17 -- .../alter_mview_add_table_parameter_msql.sql | 4 - .../tests/ppas/11_plus/alter_mview_definition.sql | 12 - .../ppas/11_plus/alter_mview_definition_msql.sql | 4 - .../ppas/11_plus/alter_mview_drop_all_priv.sql | 17 -- .../11_plus/alter_mview_drop_all_priv_msql.sql | 1 - .../views/tests/ppas/11_plus/alter_mview_msql.sql | 1 - .../11_plus/alter_mview_remove_table_parameter.sql | 16 -- .../alter_mview_remove_table_parameter_msql.sql | 6 - .../views/tests/ppas/11_plus/alter_view.sql | 18 -- .../ppas/11_plus/alter_view_add_some_priv.sql | 19 -- .../ppas/11_plus/alter_view_add_some_priv_msql.sql | 1 - .../tests/ppas/11_plus/alter_view_definition.sql | 18 -- .../ppas/11_plus/alter_view_definition_msql.sql | 4 - .../tests/ppas/11_plus/alter_view_delete_priv.sql | 18 -- .../ppas/11_plus/alter_view_delete_priv_msql.sql | 1 - .../views/tests/ppas/11_plus/alter_view_msql.sql | 7 - .../views/tests/ppas/11_plus/create_mview.sql | 15 -- .../views/tests/ppas/11_plus/create_mview_msql.sql | 11 - .../views/tests/ppas/11_plus/create_view.sql | 17 -- .../views/tests/ppas/11_plus/create_view_msql.sql | 12 - .../views/tests/ppas/11_plus/test_mview.json | 256 --------------------- .../schemas/views/tests/ppas/11_plus/tests.json | 178 -------------- .../ppas/9.4_plus/alter_mview_add_fillfactor.sql | 5 +- .../9.4_plus/alter_mview_add_fillfactor_msql.sql | 2 +- .../9.4_plus/alter_mview_add_table_parameter.sql | 5 +- .../tests/ppas/9.4_plus/alter_mview_definition.sql | 5 +- .../ppas/9.4_plus/alter_mview_definition_msql.sql | 4 + .../alter_mview_remove_table_parameter.sql | 5 +- .../ppas/9.4_plus/alter_view_add_some_priv.sql | 2 +- .../9.4_plus/alter_view_add_some_priv_msql.sql | 2 +- .../views/tests/ppas/9.4_plus/test_mview.json | 2 +- .../schemas/views/tests/ppas/9.4_plus/tests.json | 22 +- web/pgadmin/browser/static/js/node.js | 43 +++- 52 files changed, 150 insertions(+), 777 deletions(-)
