pgAdmin 4 commit: Added appropriate 'IF EXISTS', 'CASCADE', 'IF NOT EXI - Mailing list pgadmin-hackers
From | Akshay Joshi |
---|---|
Subject | pgAdmin 4 commit: Added appropriate 'IF EXISTS', 'CASCADE', 'IF NOT EXI |
Date | |
Msg-id | E1mVC8D-00089u-Th@gothos.postgresql.org Whole thread Raw |
List | 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.mohite@enterprisedb.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(-)
pgadmin-hackers by date: