Ensure objects depending on extensions are not displayed in Schema Diff. Fixes #7221
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=473afd950c88c900d8bd5bdf00cb4ac245da0979 Modified Files -------------- docs/en_US/release_notes_6_8.rst | 1 + .../server_groups/servers/databases/casts/__init__.py | 5 +++-- .../databases/casts/templates/casts/sql/default/nodes.sql | 4 ++++ .../servers/databases/event_triggers/__init__.py | 9 ++------- .../templates/event_triggers/sql/9.3_plus/nodes.sql | 4 ++++ .../server_groups/servers/databases/extensions/__init__.py | 2 +- .../servers/databases/foreign_data_wrappers/__init__.py | 3 ++- .../foreign_data_wrappers/foreign_servers/__init__.py | 3 ++- .../templates/foreign_servers/sql/9.3_plus/properties.sql | 4 ++++ .../foreign_servers/user_mappings/__init__.py | 5 +++-- .../templates/user_mappings/sql/default/properties.sql | 4 ++++ .../foreign_data_wrappers/sql/9.3_plus/properties.sql | 4 ++++ .../server_groups/servers/databases/languages/__init__.py | 3 ++- .../languages/templates/languages/sql/default/properties.sql | 4 ++++ .../server_groups/servers/databases/publications/__init__.py | 11 +++-------- .../templates/publications/sql/default/nodes.sql | 7 ++++++- .../servers/databases/schemas/collations/__init__.py | 3 ++- .../collations/templates/collations/sql/default/nodes.sql | 4 ++++ .../servers/databases/schemas/domains/__init__.py | 5 +++-- .../schemas/domains/templates/domains/sql/9.2_plus/node.sql | 4 ++++ .../servers/databases/schemas/foreign_tables/__init__.py | 3 ++- .../templates/foreign_tables/sql/default/node.sql | 4 ++++ .../servers/databases/schemas/fts_configurations/__init__.py | 5 +++-- .../templates/fts_configurations/sql/default/nodes.sql | 4 ++++ .../servers/databases/schemas/fts_dictionaries/__init__.py | 3 ++- .../templates/fts_dictionaries/sql/default/nodes.sql | 5 ++++- .../servers/databases/schemas/fts_parsers/__init__.py | 5 +++-- .../fts_parsers/templates/fts_parsers/sql/default/nodes.sql | 5 ++++- .../servers/databases/schemas/fts_templates/__init__.py | 5 +++-- .../templates/fts_templates/sql/default/nodes.sql | 5 ++++- .../servers/databases/schemas/functions/__init__.py | 3 ++- .../functions/templates/functions/pg/sql/11_plus/node.sql | 4 ++++ .../functions/templates/functions/pg/sql/default/node.sql | 4 ++++ .../functions/templates/functions/ppas/sql/11_plus/node.sql | 4 ++++ .../functions/templates/functions/ppas/sql/default/node.sql | 4 ++++ .../functions/templates/procedures/pg/sql/11_plus/node.sql | 4 ++++ .../functions/templates/procedures/ppas/sql/11_plus/node.sql | 4 ++++ .../functions/templates/procedures/ppas/sql/default/node.sql | 4 ++++ .../templates/trigger_functions/pg/sql/11_plus/node.sql | 4 ++++ .../templates/trigger_functions/pg/sql/9.2_plus/node.sql | 4 ++++ .../templates/trigger_functions/pg/sql/9.5_plus/node.sql | 4 ++++ .../templates/trigger_functions/ppas/sql/11_plus/node.sql | 4 ++++ .../templates/trigger_functions/ppas/sql/9.2_plus/node.sql | 4 ++++ .../servers/databases/schemas/packages/__init__.py | 3 ++- .../packages/templates/packages/ppas/12_plus/nodes.sql | 4 ++++ .../packages/templates/packages/ppas/9.1_plus/nodes.sql | 4 ++++ .../packages/templates/packages/ppas/9.2_plus/nodes.sql | 4 ++++ .../servers/databases/schemas/sequences/__init__.py | 3 ++- .../sequences/templates/sequences/sql/default/nodes.sql | 4 ++++ .../servers/databases/schemas/synonyms/__init__.py | 3 ++- .../synonyms/templates/synonyms/sql/9.2_plus/properties.sql | 4 ++++ .../synonyms/templates/synonyms/sql/9.5_plus/properties.sql | 4 ++++ .../synonyms/templates/synonyms/sql/default/properties.sql | 4 ++++ .../databases/schemas/tables/compound_triggers/__init__.py | 3 ++- .../servers/databases/schemas/tables/indexes/__init__.py | 3 ++- .../servers/databases/schemas/tables/partitions/__init__.py | 2 +- .../schemas/tables/row_security_policies/__init__.py | 3 ++- .../servers/databases/schemas/tables/rules/__init__.py | 2 +- .../templates/compound_triggers/sql/ppas/12_plus/nodes.sql | 4 ++++ .../schemas/tables/templates/indexes/sql/default/nodes.sql | 4 ++++ .../tables/templates/partitions/sql/pg/10_plus/nodes.sql | 4 ++++ .../tables/templates/partitions/sql/ppas/10_plus/nodes.sql | 4 ++++ .../templates/row_security_policies/sql/9.5_plus/nodes.sql | 4 ++++ .../templates/row_security_policies/sql/default/nodes.sql | 4 ++++ .../databases/schemas/tables/templates/rules/sql/nodes.sql | 4 ++++ .../schemas/tables/templates/tables/sql/10_plus/nodes.sql | 4 ++++ .../schemas/tables/templates/tables/sql/9.1_plus/nodes.sql | 4 ++++ .../tables/templates/triggers/sql/pg/9.1_plus/nodes.sql | 4 ++++ .../tables/templates/triggers/sql/ppas/9.1_plus/nodes.sql | 4 ++++ .../servers/databases/schemas/tables/triggers/__init__.py | 3 ++- .../server_groups/servers/databases/schemas/tables/utils.py | 3 ++- .../servers/databases/schemas/types/__init__.py | 3 ++- .../schemas/types/templates/types/pg/sql/default/nodes.sql | 4 ++++ .../schemas/types/templates/types/ppas/sql/default/nodes.sql | 4 ++++ .../servers/databases/schemas/views/__init__.py | 6 ++++-- .../schemas/views/templates/mviews/pg/9.3_plus/sql/nodes.sql | 4 ++++ .../schemas/views/templates/mviews/pg/9.4_plus/sql/nodes.sql | 4 ++++ .../views/templates/mviews/ppas/9.3_plus/sql/nodes.sql | 4 ++++ .../schemas/views/templates/views/pg/9.1_plus/sql/nodes.sql | 4 ++++ .../schemas/views/templates/views/pg/9.2_plus/sql/nodes.sql | 4 ++++ .../schemas/views/templates/views/pg/9.3_plus/sql/nodes.sql | 4 ++++ .../schemas/views/templates/views/pg/9.4_plus/sql/nodes.sql | 4 ++++ .../views/templates/views/ppas/9.1_plus/sql/nodes.sql | 4 ++++ .../views/templates/views/ppas/9.2_plus/sql/nodes.sql | 4 ++++ .../views/templates/views/ppas/9.3_plus/sql/nodes.sql | 4 ++++ .../views/templates/views/ppas/9.4_plus/sql/nodes.sql | 4 ++++ .../servers/databases/subscriptions/__init__.py | 12 +++--------- .../templates/subscriptions/sql/default/nodes.sql | 8 ++++++-- .../server_groups/servers/resource_groups/__init__.py | 8 ++++---- 89 files changed, 306 insertions(+), 67 deletions(-)