pgAdmin 4 commit: Added appropriate 'IF EXISTS', 'CASCADE', 'IF NOT EXI

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 commit: Added appropriate 'IF EXISTS', 'CASCADE', 'IF NOT EXI
Date: 2021-09-28 12:22:45
Message-ID: E1mVC8D-00089u-Th@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Added appropriate 'IF EXISTS', 'CASCADE', 'IF NOT EXISTS' clause for the remaining nodes.

refs #5741

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c4db223a64f6461450b161875e884346f0f9a684
Author: Nikhil Mohite <nikhil(dot)mohite(at)enterprisedb(dot)com>

Modified Files
--------------
.../server_groups/servers/databases/foreign_data_wrappers/__init__.py | 2 +-
.../databases/foreign_data_wrappers/foreign_servers/__init__.py | 2 +-
.../foreign_servers/tests/pg/9.3_plus/alter_comment_version.sql | 2 +-
.../foreign_servers/tests/pg/9.3_plus/alter_options_privileges.sql | 2 +-
.../foreign_servers/tests/pg/9.3_plus/alter_remove_options_priv.sql | 2 +-
.../foreign_servers/tests/pg/9.3_plus/create_fs_all_options.sql | 2 +-
.../foreign_servers/tests/ppas/9.3_plus/alter_comment_version.sql | 2 +-
.../foreign_servers/tests/ppas/9.3_plus/alter_options_privileges.sql | 2 +-
.../foreign_servers/tests/ppas/9.3_plus/alter_remove_options_priv.sql | 2 +-
.../foreign_servers/tests/ppas/9.3_plus/create_fs_all_options.sql | 2 +-
.../foreign_data_wrappers/foreign_servers/user_mappings/__init__.py | 2 +-
.../user_mappings/templates/user_mappings/sql/default/create.sql | 2 +-
.../foreign_servers/user_mappings/tests/pg/default/alter_options.sql | 2 +-
.../user_mappings/tests/pg/default/alter_options_deleted.sql | 2 +-
.../user_mappings/tests/pg/default/create_user_mapping.sql | 2 +-
.../user_mappings/tests/ppas/default/alter_options.sql | 2 +-
.../user_mappings/tests/ppas/default/alter_options_deleted.sql | 2 +-
.../user_mappings/tests/ppas/default/create_user_mapping.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_change_opt2.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_comment.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_opt1.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_opt2.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_privileges.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_rename.sql | 2 +-
.../foreign_data_wrappers/tests/pg/9.3_plus/alter_fdw_validator.sql | 2 +-
.../databases/foreign_data_wrappers/tests/pg/9.3_plus/create_fdw.sql | 2 +-
.../tests/ppas/9.3_plus/alter_fdw_change_opt2.sql | 2 +-
.../foreign_data_wrappers/tests/ppas/9.3_plus/alter_fdw_comment.sql | 2 +-
.../foreign_data_wrappers/tests/ppas/9.3_plus/alter_fdw_opt1.sql | 2 +-
.../foreign_data_wrappers/tests/ppas/9.3_plus/alter_fdw_opt2.sql | 2 +-
.../tests/ppas/9.3_plus/alter_fdw_privileges.sql | 2 +-
.../foreign_data_wrappers/tests/ppas/9.3_plus/alter_fdw_rename.sql | 2 +-
.../foreign_data_wrappers/tests/ppas/9.3_plus/alter_fdw_validator.sql | 2 +-
.../foreign_data_wrappers/tests/ppas/9.3_plus/create_fdw.sql | 2 +-
.../browser/server_groups/servers/databases/schemas/__init__.py | 2 +-
.../server_groups/servers/databases/schemas/domains/__init__.py | 2 +-
.../schemas/domains/tests/pg/default/alter_domain_comment.sql | 2 +-
.../domains/tests/pg/default/alter_domain_default_expression.sql | 2 +-
.../databases/schemas/domains/tests/pg/default/alter_domain_name.sql | 2 +-
.../schemas/domains/tests/pg/default/alter_domain_null_type.sql | 2 +-
.../databases/schemas/domains/tests/pg/default/create_domain.sql | 2 +-
.../schemas/domains/tests/pg/default/create_domain_numeric.sql | 2 +-
.../schemas/domains/tests/ppas/default/alter_domain_comment.sql | 2 +-
.../domains/tests/ppas/default/alter_domain_default_expression.sql | 2 +-
.../schemas/domains/tests/ppas/default/alter_domain_name.sql | 2 +-
.../schemas/domains/tests/ppas/default/alter_domain_null_type.sql | 2 +-
.../databases/schemas/domains/tests/ppas/default/create_domain.sql | 2 +-
.../schemas/domains/tests/ppas/default/create_domain_numeric.sql | 2 +-
.../servers/databases/schemas/foreign_tables/__init__.py | 2 +-
.../schemas/foreign_tables/tests/pg/9.2_plus/alter_add_opts.sql | 2 +-
.../schemas/foreign_tables/tests/pg/9.2_plus/alter_add_priv.sql | 2 +-
.../schemas/foreign_tables/tests/pg/9.2_plus/alter_col_opts.sql | 2 +-
.../foreign_tables/tests/pg/9.2_plus/alter_comment_add_columns.sql | 2 +-
.../foreign_tables/tests/pg/9.2_plus/alter_remove_opts_priv.sql | 2 +-
.../tests/pg/9.2_plus/create_foreign_table_with_all_options.sql | 2 +-
.../schemas/foreign_tables/tests/pg/9.6_plus/alter_add_cons_opts.sql | 2 +-
.../schemas/foreign_tables/tests/pg/9.6_plus/alter_add_priv.sql | 2 +-
.../schemas/foreign_tables/tests/pg/9.6_plus/alter_col_opts.sql | 2 +-
.../foreign_tables/tests/pg/9.6_plus/alter_comment_add_columns.sql | 2 +-
.../foreign_tables/tests/pg/9.6_plus/alter_remove_opts_priv_cons.sql | 2 +-
.../tests/pg/9.6_plus/create_foreign_table_with_all_options.sql | 2 +-
.../schemas/foreign_tables/tests/ppas/9.2_plus/alter_add_priv.sql | 2 +-
.../schemas/foreign_tables/tests/ppas/9.2_plus/alter_column.sql | 2 +-
.../foreign_tables/tests/ppas/9.2_plus/alter_comment_add_columns.sql | 2 +-
.../schemas/foreign_tables/tests/ppas/9.2_plus/alter_remove_priv.sql | 2 +-
.../tests/ppas/9.2_plus/create_foreign_table_with_all_options.sql | 2 +-
.../foreign_tables/tests/ppas/9.6_plus/alter_add_cons_opts.sql | 2 +-
.../schemas/foreign_tables/tests/ppas/9.6_plus/alter_add_priv.sql | 2 +-
.../schemas/foreign_tables/tests/ppas/9.6_plus/alter_col_opts.sql | 2 +-
.../foreign_tables/tests/ppas/9.6_plus/alter_comment_add_columns.sql | 2 +-
.../tests/ppas/9.6_plus/alter_remove_opts_priv_cons.sql | 2 +-
.../tests/ppas/9.6_plus/create_foreign_table_with_all_options.sql | 2 +-
.../fts_configurations/tests/default/create_fts_dictionary.sql | 2 +-
.../servers/databases/schemas/fts_dictionaries/__init__.py | 2 +-
.../tests/default/alter_fts_dictionary_delete_options.sql | 2 +-
.../fts_dictionaries/tests/default/alter_fts_dictionary_options.sql | 2 +-
.../schemas/fts_dictionaries/tests/default/create_fts_dictionary.sql | 2 +-
.../server_groups/servers/databases/schemas/sequences/__init__.py | 2 +-
.../schemas/sequences/tests/pg/default/alter_neg_seq_props.sql | 2 +-
.../schemas/sequences/tests/pg/default/alter_ownedby_column.sql | 2 +-
.../schemas/sequences/tests/pg/default/alter_ownedby_remove.sql | 2 +-
.../sequences/tests/pg/default/alter_seq_change_grantee_privs.sql | 2 +-
.../schemas/sequences/tests/pg/default/alter_seq_comment.sql | 2 +-
.../schemas/sequences/tests/pg/default/alter_seq_privs_add.sql | 2 +-
.../schemas/sequences/tests/pg/default/alter_seq_privs_remove.sql | 2 +-
.../schemas/sequences/tests/pg/default/alter_seq_privs_update.sql | 2 +-
.../databases/schemas/sequences/tests/pg/default/alter_seq_props.sql | 2 +-
.../schemas/sequences/tests/pg/default/create_negative_sequence.sql | 2 +-
.../databases/schemas/sequences/tests/pg/default/create_sequence.sql | 2 +-
.../schemas/sequences/tests/pg/default/create_sequence_ownedby.sql | 2 +-
.../sequences/tests/pg/default/create_sequence_ownedby_remove.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_neg_seq_props.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_ownedby_column.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_ownedby_remove.sql | 2 +-
.../sequences/tests/ppas/default/alter_seq_change_grantee_privs.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_seq_comment.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_seq_privs_add.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_seq_privs_remove.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_seq_privs_update.sql | 2 +-
.../schemas/sequences/tests/ppas/default/alter_seq_props.sql | 2 +-
.../schemas/sequences/tests/ppas/default/create_negative_sequence.sql | 2 +-
.../schemas/sequences/tests/ppas/default/create_sequence.sql | 2 +-
.../schemas/sequences/tests/ppas/default/create_sequence_ownedby.sql | 2 +-
.../sequences/tests/ppas/default/create_sequence_ownedby_remove.sql | 2 +-
.../server_groups/servers/databases/schemas/tables/rules/__init__.py | 4 +++-
.../schemas/tables/rules/tests/default/alter_delete_event_rule.sql | 4 ++--
.../schemas/tables/rules/tests/default/alter_insert_event_rule.sql | 4 ++--
.../tables/rules/tests/default/alter_insert_event_rule_complex.sql | 4 ++--
.../tables/rules/tests/default/alter_insert_event_rule_nothing.sql | 4 ++--
.../rules/tests/default/alter_insert_event_rule_nothing_update.sql | 4 ++--
.../schemas/tables/rules/tests/default/alter_update_event_rule.sql | 4 ++--
.../schemas/tables/rules/tests/default/create_delete_event_rule.sql | 4 ++--
.../schemas/tables/rules/tests/default/create_insert_event_rule.sql | 4 ++--
.../schemas/tables/rules/tests/default/create_update_event_rule.sql | 4 ++--
.../servers/databases/schemas/tables/templates/rules/sql/create.sql | 2 +-
.../databases/schemas/templates/schemas/pg/default/sql/create.sql | 2 +-
.../databases/schemas/templates/schemas/ppas/9.2_plus/sql/create.sql | 2 +-
.../schemas/tests/ppas/9.2_plus/create_schema_all_options_msql.sql | 2 +-
.../schemas/tests/ppas/9.2_plus/create_schema_with_comment_msql.sql | 2 +-
.../browser/server_groups/servers/databases/subscriptions/__init__.py | 3 ++-
.../databases/subscriptions/tests/10_plus/alter_maintenance_db.sql | 2 +-
.../databases/subscriptions/tests/10_plus/alter_subscription.sql | 2 +-
.../servers/databases/subscriptions/tests/10_plus/alter_sync.sql | 2 +-
.../databases/subscriptions/tests/10_plus/create_subscription.sql | 2 +-
124 files changed, 136 insertions(+), 133 deletions(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2021-09-28 12:23:07 Re: [pgAdmin4][Patch] - Fixes for RM #6817 & RM #6820
Previous Message Aditya Toshniwal 2021-09-28 11:48:47 Re: [pgAdmin][RM6778] Properties panel not loaded for catalog tables