Revisit all the CREATE and DROP DDL's to add appropriate 'IF EXISTS', 'CASCADE' and 'CREATE OR REPLACE'. Fixes #5741
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6021e0776106790d5e7dd7dee07495817e0c5e0a Author: Nikhil Mohite <nikhil.moh...@enterprisedb.com> Modified Files -------------- .../casts/templates/casts/sql/default/delete.sql | 2 +- .../extensions/templates/extensions/sql/create.sql | 2 +- .../extensions/templates/extensions/sql/delete.sql | 2 +- .../tests/9.4_plus/alter_extension_schema.sql | 2 +- .../tests/9.4_plus/alter_extension_version.sql | 2 +- .../9.4_plus/create_extension_with_all_options.sql | 2 +- .../create_extension_with_default_schema.sql | 2 +- .../msql_create_extension_with_all_options.sql | 2 +- .../msql_create_extension_with_default_schema.sql | 2 +- .../tests/9.5_plus/alter_extension_schema.sql | 2 +- .../9.5_plus/create_extension_with_all_options.sql | 2 +- .../msql_create_extension_with_all_options.sql | 2 +- .../tests/9.6_plus/alter_extension_schema.sql | 2 +- .../tests/9.6_plus/alter_extension_version.sql | 2 +- .../9.6_plus/create_extension_with_all_options.sql | 2 +- .../create_extension_with_default_schema.sql | 2 +- .../msql_create_extension_with_all_options.sql | 2 +- .../msql_create_extension_with_default_schema.sql | 2 +- .../foreign_data_wrappers/sql/default/delete.sql | 2 +- .../templates/languages/sql/default/delete.sql | 2 +- .../templates/publications/sql/default/delete.sql | 2 +- .../tests/10_plus/alter_publication.sql | 2 +- .../tests/10_plus/alter_publication_event.sql | 2 +- .../tests/10_plus/create_publication.sql | 2 +- .../tests/13_plus/alter_publication.sql | 2 +- .../tests/13_plus/alter_publication_event.sql | 2 +- .../tests/13_plus/create_publication.sql | 2 +- .../templates/collations/sql/default/delete.sql | 2 +- .../collations/tests/default/alter_collation.sql | 2 +- .../collations/tests/default/create_collation.sql | 2 +- .../templates/domains/sql/default/delete.sql | 2 +- .../foreign_tables/sql/9.5_plus/create.sql | 2 +- .../foreign_tables/sql/9.5_plus/update.sql | 44 ++++++++++---------- .../tests/pg/9.6_plus/alter_add_cons_opts.sql | 2 +- .../tests/pg/9.6_plus/alter_add_cons_opts_msql.sql | 6 +-- .../tests/pg/9.6_plus/alter_add_priv.sql | 2 +- .../tests/pg/9.6_plus/alter_col_opts.sql | 2 +- .../tests/pg/9.6_plus/alter_col_opts_msql.sql | 10 ++--- .../pg/9.6_plus/alter_comment_add_columns.sql | 2 +- .../pg/9.6_plus/alter_comment_add_columns_msql.sql | 4 +- .../pg/9.6_plus/alter_remove_opts_priv_cons.sql | 2 +- .../9.6_plus/alter_remove_opts_priv_cons_msql.sql | 4 +- .../create_foreign_table_with_all_options.sql | 2 +- .../create_foreign_table_with_all_options_msql.sql | 2 +- .../tests/ppas/9.2_plus/alter_add_priv.sql | 2 +- .../ppas/9.2_plus/alter_comment_add_columns.sql | 2 +- .../9.2_plus/alter_comment_add_columns_msql.sql | 4 +- .../create_foreign_table_with_all_options.sql | 2 +- .../create_foreign_table_with_all_options_msql.sql | 2 +- .../tests/ppas/9.6_plus/alter_add_cons_opts.sql | 2 +- .../ppas/9.6_plus/alter_add_cons_opts_msql.sql | 6 +-- .../tests/ppas/9.6_plus/alter_add_priv.sql | 2 +- .../tests/ppas/9.6_plus/alter_col_opts.sql | 2 +- .../tests/ppas/9.6_plus/alter_col_opts_msql.sql | 10 ++--- .../ppas/9.6_plus/alter_comment_add_columns.sql | 2 +- .../9.6_plus/alter_comment_add_columns_msql.sql | 4 +- .../ppas/9.6_plus/alter_remove_opts_priv_cons.sql | 2 +- .../9.6_plus/alter_remove_opts_priv_cons_msql.sql | 4 +- .../create_foreign_table_with_all_options.sql | 2 +- .../create_foreign_table_with_all_options_msql.sql | 2 +- .../fts_configurations/sql/default/delete.sql | 4 +- .../fts_dictionaries/sql/default/delete.sql | 2 +- .../templates/fts_parsers/sql/default/delete.sql | 2 +- .../templates/fts_templates/sql/default/delete.sql | 2 +- .../templates/functions/pg/sql/11_plus/delete.sql | 2 +- .../templates/functions/pg/sql/9.6_plus/delete.sql | 21 ++++++++++ .../functions/ppas/sql/11_plus/delete.sql | 2 +- .../functions/ppas/sql/9.6_plus/delete.sql | 21 ++++++++++ .../templates/procedures/pg/sql/11_plus/delete.sql | 2 +- .../procedures/ppas/sql/11_plus/delete.sql | 2 +- .../templates/sequences/sql/default/create.sql | 2 +- .../templates/sequences/sql/default/delete.sql | 2 +- .../templates/sequences/sql/default/update.sql | 8 ++-- .../tests/pg/default/alter_neg_seq_props.sql | 2 +- .../tests/pg/default/alter_neg_seq_props_msql.sql | 2 +- .../pg/default/alter_seq_change_grantee_privs.sql | 2 +- .../tests/pg/default/alter_seq_comment.sql | 2 +- .../tests/pg/default/alter_seq_privs_add.sql | 2 +- .../tests/pg/default/alter_seq_privs_remove.sql | 2 +- .../tests/pg/default/alter_seq_privs_update.sql | 2 +- .../sequences/tests/pg/default/alter_seq_props.sql | 2 +- .../tests/pg/default/alter_seq_props_msql.sql | 2 +- .../tests/pg/default/create_negative_sequence.sql | 2 +- .../pg/default/create_negative_sequence_msql.sql | 2 +- .../sequences/tests/pg/default/create_sequence.sql | 2 +- .../tests/pg/default/create_sequence_msql.sql | 2 +- .../tests/ppas/default/alter_neg_seq_props.sql | 2 +- .../ppas/default/alter_neg_seq_props_msql.sql | 2 +- .../default/alter_seq_change_grantee_privs.sql | 2 +- .../tests/ppas/default/alter_seq_comment.sql | 2 +- .../tests/ppas/default/alter_seq_privs_add.sql | 2 +- .../tests/ppas/default/alter_seq_privs_remove.sql | 2 +- .../tests/ppas/default/alter_seq_privs_update.sql | 2 +- .../tests/ppas/default/alter_seq_props.sql | 2 +- .../tests/ppas/default/alter_seq_props_msql.sql | 2 +- .../ppas/default/create_negative_sequence.sql | 2 +- .../ppas/default/create_negative_sequence_msql.sql | 2 +- .../tests/ppas/default/create_sequence.sql | 2 +- .../tests/ppas/default/create_sequence_msql.sql | 2 +- .../pg/10_plus/alter_column_alt_privilege.sql | 6 +-- .../tests/pg/10_plus/alter_column_char.msql | 8 ++-- .../columns/tests/pg/10_plus/alter_column_char.sql | 10 ++--- .../pg/10_plus/alter_column_drop_identity.msql | 4 +- .../pg/10_plus/alter_column_drop_identity.sql | 6 +-- .../alter_column_drop_identity_by_default.msql | 4 +- .../alter_column_drop_identity_by_default.sql | 6 +-- .../tests/pg/10_plus/alter_column_identity.msql | 4 +- .../tests/pg/10_plus/alter_column_identity.sql | 6 +-- .../10_plus/alter_column_identity_by_default.msql | 4 +- .../10_plus/alter_column_identity_by_default.sql | 6 +-- .../alter_column_identity_for_comb_start_seq.msql | 2 +- .../alter_column_identity_for_comb_start_seq.sql | 6 +-- .../alter_column_identity_for_restart_seq.msql | 2 +- .../alter_column_identity_for_restart_seq.sql | 6 +-- .../columns/tests/pg/10_plus/alter_column_int.msql | 4 +- .../columns/tests/pg/10_plus/alter_column_int.sql | 6 +-- .../tests/pg/10_plus/alter_column_numeric.msql | 4 +- .../tests/pg/10_plus/alter_column_numeric.sql | 8 ++-- .../pg/10_plus/alter_column_remove_length.sql | 8 ++-- .../alter_column_text_with_default_value.msql | 2 +- .../alter_column_text_with_default_value.sql | 6 +-- ...imestamp_with_default_value_using_function.msql | 2 +- ...timestamp_with_default_value_using_function.sql | 6 +-- ...ter_column_with_interger_array_and_options.msql | 2 +- ...lter_column_with_interger_array_and_options.sql | 8 ++-- .../tests/pg/10_plus/create_column_char.msql | 4 +- .../tests/pg/10_plus/create_column_char.sql | 6 +-- .../create_column_identity_for_restart_seq.msql | 4 +- .../create_column_identity_for_restart_seq.sql | 6 +-- .../tests/pg/10_plus/create_column_int.msql | 4 +- .../columns/tests/pg/10_plus/create_column_int.sql | 6 +-- .../pg/10_plus/create_column_int_identity.msql | 4 +- .../pg/10_plus/create_column_int_identity.sql | 6 +-- .../create_column_int_identity_by_default.msql | 4 +- .../create_column_int_identity_by_default.sql | 6 +-- .../tests/pg/10_plus/create_column_numeric.msql | 8 ++-- .../tests/pg/10_plus/create_column_numeric.sql | 8 ++-- .../create_column_text_with_default_value.msql | 4 +- .../create_column_text_with_default_value.sql | 6 +-- ...imestamp_with_default_value_using_function.msql | 4 +- ...timestamp_with_default_value_using_function.sql | 6 +-- ...ate_column_with_interger_array_and_options.msql | 6 +-- ...eate_column_with_interger_array_and_options.sql | 8 ++-- .../pg/12_plus/alter_column_alt_privilege.sql | 4 +- .../tests/pg/12_plus/alter_column_char.msql | 6 +-- .../columns/tests/pg/12_plus/alter_column_char.sql | 8 ++-- .../pg/12_plus/alter_column_drop_identity.msql | 4 +- .../pg/12_plus/alter_column_drop_identity.sql | 4 +- .../alter_column_drop_identity_by_default.msql | 4 +- .../alter_column_drop_identity_by_default.sql | 4 +- .../tests/pg/12_plus/alter_column_generated.msql | 4 +- .../tests/pg/12_plus/alter_column_generated.sql | 4 +- ...ter_column_generated_with_existing_columns.msql | 4 +- ...lter_column_generated_with_existing_columns.sql | 4 +- .../tests/pg/12_plus/alter_column_identity.msql | 4 +- .../tests/pg/12_plus/alter_column_identity.sql | 4 +- .../12_plus/alter_column_identity_by_default.msql | 4 +- .../12_plus/alter_column_identity_by_default.sql | 4 +- .../alter_column_identity_for_comb_start_seq.msql | 2 +- .../alter_column_identity_for_comb_start_seq.sql | 4 +- .../alter_column_identity_for_restart_seq.msql | 2 +- .../alter_column_identity_for_restart_seq.sql | 4 +- .../columns/tests/pg/12_plus/alter_column_int.msql | 4 +- .../columns/tests/pg/12_plus/alter_column_int.sql | 4 +- .../tests/pg/12_plus/alter_column_numeric.msql | 4 +- .../tests/pg/12_plus/alter_column_numeric.sql | 6 +-- .../pg/12_plus/alter_column_remove_length.msql | 2 +- .../pg/12_plus/alter_column_remove_length.sql | 6 +-- .../alter_column_text_with_default_value.msql | 2 +- .../alter_column_text_with_default_value.sql | 4 +- ...imestamp_with_default_value_using_function.msql | 2 +- ...timestamp_with_default_value_using_function.sql | 4 +- ...ter_column_with_interger_array_and_options.msql | 2 +- ...lter_column_with_interger_array_and_options.sql | 6 +-- .../tests/pg/12_plus/create_column_char.msql | 2 +- .../tests/pg/12_plus/create_column_char.sql | 4 +- .../create_column_identity_for_restart_seq.msql | 2 +- .../create_column_identity_for_restart_seq.sql | 4 +- .../tests/pg/12_plus/create_column_int.msql | 2 +- .../columns/tests/pg/12_plus/create_column_int.sql | 4 +- .../pg/12_plus/create_column_int_generated.msql | 2 +- .../pg/12_plus/create_column_int_generated.sql | 4 +- ...column_int_generated_with_existing_columns.msql | 2 +- ..._column_int_generated_with_existing_columns.sql | 4 +- .../pg/12_plus/create_column_int_identity.msql | 2 +- .../pg/12_plus/create_column_int_identity.sql | 4 +- .../create_column_int_identity_by_default.msql | 2 +- .../create_column_int_identity_by_default.sql | 4 +- .../tests/pg/12_plus/create_column_numeric.msql | 6 +-- .../tests/pg/12_plus/create_column_numeric.sql | 6 +-- .../create_column_text_with_default_value.msql | 2 +- .../create_column_text_with_default_value.sql | 4 +- ...imestamp_with_default_value_using_function.msql | 2 +- ...timestamp_with_default_value_using_function.sql | 4 +- ...ate_column_with_interger_array_and_options.msql | 4 +- ...eate_column_with_interger_array_and_options.sql | 6 +-- .../pg/default/alter_column_alt_privilege.sql | 6 +-- .../tests/pg/default/alter_column_char.msql | 8 ++-- .../columns/tests/pg/default/alter_column_char.sql | 10 ++--- .../columns/tests/pg/default/alter_column_int.msql | 4 +- .../columns/tests/pg/default/alter_column_int.sql | 6 +-- .../tests/pg/default/alter_column_numeric.msql | 4 +- .../tests/pg/default/alter_column_numeric.sql | 8 ++-- .../pg/default/alter_column_remove_length.sql | 8 ++-- .../tests/pg/default/create_column_char.msql | 4 +- .../tests/pg/default/create_column_char.sql | 6 +-- .../tests/pg/default/create_column_int.msql | 4 +- .../columns/tests/pg/default/create_column_int.sql | 6 +-- .../tests/pg/default/create_column_numeric.msql | 8 ++-- .../tests/pg/default/create_column_numeric.sql | 8 ++-- .../ppas/10_plus/alter_column_alt_privilege.sql | 6 +-- .../tests/ppas/10_plus/alter_column_char.msql | 8 ++-- .../tests/ppas/10_plus/alter_column_char.sql | 10 ++--- .../ppas/10_plus/alter_column_drop_identity.msql | 4 +- .../ppas/10_plus/alter_column_drop_identity.sql | 6 +-- .../alter_column_drop_identity_by_default.msql | 4 +- .../alter_column_drop_identity_by_default.sql | 6 +-- .../tests/ppas/10_plus/alter_column_identity.msql | 4 +- .../tests/ppas/10_plus/alter_column_identity.sql | 6 +-- .../10_plus/alter_column_identity_by_default.msql | 4 +- .../10_plus/alter_column_identity_by_default.sql | 6 +-- .../alter_column_identity_for_comb_start_seq.msql | 2 +- .../alter_column_identity_for_comb_start_seq.sql | 6 +-- .../alter_column_identity_for_restart_seq.msql | 2 +- .../alter_column_identity_for_restart_seq.sql | 6 +-- .../tests/ppas/10_plus/alter_column_int.msql | 4 +- .../tests/ppas/10_plus/alter_column_int.sql | 6 +-- .../tests/ppas/10_plus/alter_column_numeric.msql | 4 +- .../tests/ppas/10_plus/alter_column_numeric.sql | 8 ++-- .../ppas/10_plus/alter_column_remove_length.msql | 2 +- .../ppas/10_plus/alter_column_remove_length.sql | 8 ++-- .../tests/ppas/10_plus/create_column_char.msql | 4 +- .../tests/ppas/10_plus/create_column_char.sql | 6 +-- .../create_column_identity_for_restart_seq.msql | 4 +- .../create_column_identity_for_restart_seq.sql | 6 +-- .../tests/ppas/10_plus/create_column_int.msql | 4 +- .../tests/ppas/10_plus/create_column_int.sql | 6 +-- .../ppas/10_plus/create_column_int_identity.msql | 4 +- .../ppas/10_plus/create_column_int_identity.sql | 6 +-- .../create_column_int_identity_by_default.msql | 4 +- .../create_column_int_identity_by_default.sql | 6 +-- .../tests/ppas/10_plus/create_column_numeric.msql | 8 ++-- .../tests/ppas/10_plus/create_column_numeric.sql | 8 ++-- .../ppas/12_plus/alter_column_alt_privilege.sql | 4 +- .../tests/ppas/12_plus/alter_column_char.msql | 8 ++-- .../tests/ppas/12_plus/alter_column_char.sql | 8 ++-- .../ppas/12_plus/alter_column_drop_identity.msql | 4 +- .../ppas/12_plus/alter_column_drop_identity.sql | 4 +- .../alter_column_drop_identity_by_default.msql | 4 +- .../alter_column_drop_identity_by_default.sql | 4 +- .../tests/ppas/12_plus/alter_column_generated.msql | 4 +- .../tests/ppas/12_plus/alter_column_generated.sql | 4 +- ...ter_column_generated_with_existing_columns.msql | 4 +- ...lter_column_generated_with_existing_columns.sql | 4 +- .../tests/ppas/12_plus/alter_column_identity.msql | 4 +- .../tests/ppas/12_plus/alter_column_identity.sql | 4 +- .../12_plus/alter_column_identity_by_default.msql | 4 +- .../12_plus/alter_column_identity_by_default.sql | 4 +- .../alter_column_identity_for_comb_start_seq.msql | 2 +- .../alter_column_identity_for_comb_start_seq.sql | 4 +- .../alter_column_identity_for_restart_seq.msql | 2 +- .../alter_column_identity_for_restart_seq.sql | 4 +- .../tests/ppas/12_plus/alter_column_int.msql | 4 +- .../tests/ppas/12_plus/alter_column_int.sql | 4 +- .../tests/ppas/12_plus/alter_column_numeric.msql | 4 +- .../tests/ppas/12_plus/alter_column_numeric.sql | 6 +-- .../ppas/12_plus/alter_column_remove_length.msql | 2 +- .../ppas/12_plus/alter_column_remove_length.sql | 6 +-- .../tests/ppas/12_plus/create_column_char.msql | 2 +- .../tests/ppas/12_plus/create_column_char.sql | 4 +- .../create_column_identity_for_restart_seq.msql | 2 +- .../create_column_identity_for_restart_seq.sql | 4 +- .../tests/ppas/12_plus/create_column_int.msql | 2 +- .../tests/ppas/12_plus/create_column_int.sql | 4 +- .../ppas/12_plus/create_column_int_generated.msql | 2 +- .../ppas/12_plus/create_column_int_generated.sql | 4 +- ...column_int_generated_with_existing_columns.msql | 2 +- ..._column_int_generated_with_existing_columns.sql | 4 +- .../ppas/12_plus/create_column_int_identity.msql | 2 +- .../ppas/12_plus/create_column_int_identity.sql | 4 +- .../create_column_int_identity_by_default.msql | 2 +- .../create_column_int_identity_by_default.sql | 4 +- .../tests/ppas/12_plus/create_column_numeric.msql | 6 +-- .../tests/ppas/12_plus/create_column_numeric.sql | 6 +-- .../ppas/default/alter_column_alt_privilege.sql | 6 +-- .../tests/ppas/default/alter_column_char.msql | 8 ++-- .../tests/ppas/default/alter_column_char.sql | 10 ++--- .../tests/ppas/default/alter_column_int.msql | 4 +- .../tests/ppas/default/alter_column_int.sql | 6 +-- .../tests/ppas/default/alter_column_numeric.msql | 4 +- .../tests/ppas/default/alter_column_numeric.sql | 8 ++-- .../ppas/default/alter_column_remove_length.msql | 2 +- .../ppas/default/alter_column_remove_length.sql | 8 ++-- .../tests/ppas/default/create_column_char.msql | 4 +- .../tests/ppas/default/create_column_char.sql | 6 +-- .../tests/ppas/default/create_column_int.msql | 4 +- .../tests/ppas/default/create_column_int.sql | 6 +-- .../tests/ppas/default/create_column_numeric.msql | 8 ++-- .../tests/ppas/default/create_column_numeric.sql | 8 ++-- .../ppas/12_plus/alter_event_comment_code.sql | 2 +- .../tests/ppas/12_plus/create_for_all_event.sql | 2 +- .../ppas/12_plus/create_for_insert_delete.sql | 2 +- .../create_for_insert_update_on_columns.sql | 2 +- .../ppas/12_plus/create_for_insert_with_when.sql | 2 +- .../tests/Default/alter_check_constraint.sql | 4 +- .../tests/Default/alter_check_constraint_msql.sql | 4 +- .../tests/Default/create_check_constraint.sql | 4 +- .../Default/create_check_constraint_with_valid.sql | 4 +- .../create_check_constraint_with_valid_msql.sql | 2 +- .../tests/11_plus/alter_exclusion_constraint.sql | 4 +- .../11_plus/alter_exclusion_constraint_msql.sql | 4 +- .../tests/11_plus/create_exclusion_constraint.sql | 4 +- .../11_plus/create_exclusion_constraint_exp.sql | 4 +- .../create_exclusion_constraint_exp_msql.sql | 2 +- .../11_plus/create_exclusion_constraint_msql.sql | 2 +- .../tests/default/alter_exclusion_constraint.sql | 4 +- .../default/alter_exclusion_constraint_msql.sql | 4 +- .../tests/default/alter_without_fillfactor.sql | 4 +- .../default/alter_without_fillfactor_msql.sql | 4 +- .../tests/default/create_exclusion_constraint.sql | 4 +- .../default/create_exclusion_constraint_exp.sql | 4 +- .../default/create_exclusion_constraint_msql.sql | 2 +- .../tests/default/create_without_fillfactor.sql | 4 +- .../default/create_without_fillfactor_msql.sql | 2 +- .../default/exclusion_constraint_exp_msql.sql | 2 +- .../9.3_plus/alter_name_comment_validation.sql | 4 +- .../alter_name_comment_validation_msql.sql | 4 +- .../tests/9.3_plus/create_foreign_key_cascade.sql | 4 +- .../9.3_plus/create_foreign_key_cascade_msql.sql | 2 +- .../tests/9.3_plus/create_foreign_key_restrict.sql | 4 +- .../9.3_plus/create_foreign_key_restrict_msql.sql | 2 +- .../9.3_plus/create_foreign_key_setdefault.sql | 4 +- .../create_foreign_key_setdefault_msql.sql | 2 +- .../tests/9.3_plus/create_foreign_key_setnull.sql | 4 +- .../9.3_plus/create_foreign_key_setnull_msql.sql | 2 +- .../tests/9.3_plus/create_foreign_key_simple.sql | 4 +- .../9.3_plus/create_foreign_key_simple_msql.sql | 2 +- .../create_foreign_key_with_all_options.sql | 4 +- .../create_foreign_key_with_all_options_msql.sql | 4 +- .../tests/11_plus/alter_pkey_constraint.sql | 4 +- .../11_plus/alter_pkey_constraint_with_index.sql | 4 +- .../tests/11_plus/alter_pkey_reset_fillfactor.sql | 4 +- .../tests/11_plus/alter_unique_constraint.sql | 4 +- .../11_plus/alter_unique_constraint_with_index.sql | 4 +- .../11_plus/alter_unique_reset_fillfactor.sql | 4 +- .../tests/11_plus/create_pkey_constraint.sql | 4 +- .../tests/11_plus/create_pkey_constraint_msql.sql | 2 +- .../11_plus/create_pkey_constraint_with_index.sql | 4 +- .../create_pkey_constraint_with_index_msql.sql | 2 +- .../tests/11_plus/create_unique_constraint.sql | 4 +- .../11_plus/create_unique_constraint_msql.sql | 2 +- .../create_unique_constraint_with_index.sql | 4 +- .../create_unique_constraint_with_index_msql.sql | 2 +- .../tests/default/alter_pkey_constraint.sql | 4 +- .../default/alter_pkey_constraint_with_index.sql | 4 +- .../tests/default/alter_pkey_reset_fillfactor.sql | 4 +- .../tests/default/alter_unique_constraint.sql | 4 +- .../default/alter_unique_constraint_with_index.sql | 4 +- .../default/alter_unique_reset_fillfactor.sql | 4 +- .../tests/default/create_pkey_constraint.sql | 4 +- .../tests/default/create_pkey_constraint_msql.sql | 2 +- .../default/create_pkey_constraint_with_index.sql | 4 +- .../create_pkey_constraint_with_index_msql.sql | 2 +- .../tests/default/create_unique_constraint.sql | 4 +- .../default/create_unique_constraint_msql.sql | 2 +- .../create_unique_constraint_with_index.sql | 4 +- .../create_unique_constraint_with_index_msql.sql | 2 +- .../default/alter_name_fillfactor_comment.sql | 6 +-- .../default/alter_name_fillfactor_comment_msql.sql | 6 +-- .../default/alter_reset_fillfactor_cluster.sql | 4 +- .../alter_reset_fillfactor_cluster_msql.sql | 4 +- .../tests/default/create_btree_asc_null_first.sql | 4 +- .../default/create_btree_asc_null_first_msql.sql | 2 +- .../tests/default/create_btree_asc_null_last.sql | 4 +- .../default/create_btree_asc_null_last_msql.sql | 2 +- .../tests/default/create_btree_desc_null_first.sql | 4 +- .../default/create_btree_desc_null_first_msql.sql | 2 +- .../tests/default/create_btree_desc_null_last.sql | 4 +- .../default/create_btree_desc_null_last_msql.sql | 2 +- .../indexes/tests/default/create_hash_index.sql | 4 +- .../tests/default/create_hash_index_msql.sql | 2 +- .../tests/pg/10_plus/alter_table_add_partition.sql | 6 +-- .../pg/10_plus/create_table_with_partition.sql | 4 +- .../10_plus/create_table_with_partition_msql.sql | 2 +- .../tests/pg/12_plus/alter_table_add_partition.sql | 6 +-- .../pg/12_plus/create_table_with_partition.sql | 4 +- .../12_plus/create_table_with_partition_msql.sql | 2 +- .../ppas/10_plus/alter_table_add_partition.sql | 6 +-- .../ppas/10_plus/create_table_with_partition.sql | 4 +- .../10_plus/create_table_with_partition_msql.sql | 2 +- .../ppas/12_plus/alter_table_add_partition.sql | 6 +-- .../ppas/12_plus/create_table_with_partition.sql | 4 +- .../12_plus/create_table_with_partition_msql.sql | 2 +- .../10_plus/alter_delete_policy_with_using.sql | 2 +- .../tests/10_plus/alter_policy.sql | 2 +- .../tests/10_plus/alter_select_policy.sql | 2 +- .../tests/10_plus/alter_simple_all_policy.sql | 2 +- .../tests/10_plus/alter_simple_insert_policy.sql | 2 +- .../alter_update_policy_with_check_and_using.sql | 2 +- .../tests/10_plus/create_all_event_policy.sql | 2 +- .../10_plus/create_delete_policy_with_using.sql | 2 +- .../tests/10_plus/create_public_policy.sql | 2 +- .../tests/10_plus/create_select_policy.sql | 2 +- .../tests/10_plus/create_simple_all_policy.sql | 2 +- .../tests/10_plus/create_simple_insert_policy.sql | 2 +- .../create_update_policy_with_check_and_using.sql | 2 +- .../tests/12_plus/alter_select_policy.sql | 2 +- .../tests/12_plus/alter_simple_insert_policy.sql | 2 +- .../alter_update_policy_with_check_and_using.sql | 2 +- .../12_plus/create_delete_policy_with_using.sql | 2 +- .../default/alter_delete_policy_with_using.sql | 2 +- .../tests/default/alter_select_policy.sql | 2 +- .../tests/default/alter_simple_all_policy.sql | 2 +- .../tests/default/alter_simple_insert_policy.sql | 2 +- .../alter_update_policy_with_check_and_using.sql | 2 +- .../default/create_delete_policy_with_using.sql | 2 +- .../tests/default/create_select_policy.sql | 2 +- .../tests/default/create_simple_all_policy.sql | 2 +- .../tests/default/create_simple_insert_policy.sql | 2 +- .../create_update_policy_with_check_and_using.sql | 2 +- .../check_constraint/sql/9.2_plus/create.sql | 4 +- .../check_constraint/sql/9.2_plus/update.sql | 6 +-- .../check_constraint/sql/9.2_plus/validate.sql | 4 +- .../check_constraint/sql/default/delete.sql | 2 +- .../templates/columns/sql/10_plus/create.sql | 10 ++--- .../templates/columns/sql/10_plus/update.sql | 26 ++++++------ .../templates/columns/sql/12_plus/create.sql | 8 ++-- .../templates/columns/sql/9.2_plus/update.sql | 20 ++++----- .../templates/columns/sql/default/create.sql | 10 ++--- .../templates/columns/sql/default/delete.sql | 2 +- .../templates/columns/sql/default/update.sql | 18 ++++---- .../compound_triggers/sql/ppas/12_plus/delete.sql | 2 +- .../compound_triggers/sql/ppas/12_plus/update.sql | 2 +- .../exclusion_constraint/sql/11_plus/create.sql | 2 +- .../exclusion_constraint/sql/default/create.sql | 2 +- .../exclusion_constraint/sql/default/delete.sql | 4 +- .../exclusion_constraint/sql/default/update.sql | 8 ++-- .../templates/foreign_key/sql/default/create.sql | 2 +- .../foreign_key/sql/default/create_index.sql | 2 +- .../templates/foreign_key/sql/default/delete.sql | 4 +- .../templates/foreign_key/sql/default/update.sql | 4 +- .../templates/foreign_key/sql/default/validate.sql | 4 +- .../index_constraint/sql/11_plus/create.sql | 2 +- .../index_constraint/sql/default/create.sql | 2 +- .../index_constraint/sql/default/delete.sql | 4 +- .../templates/indexes/sql/11_plus/create.sql | 2 +- .../tables/templates/indexes/sql/default/alter.sql | 4 +- .../templates/indexes/sql/default/create.sql | 2 +- .../templates/indexes/sql/default/delete.sql | 2 +- .../templates/indexes/sql/default/update.sql | 12 +++--- .../templates/partitions/sql/pg/10_plus/attach.sql | 2 +- .../templates/partitions/sql/pg/10_plus/create.sql | 2 +- .../templates/partitions/sql/pg/10_plus/detach.sql | 2 +- .../partitions/sql/pg/10_plus/partition_diff.sql | 8 ++-- .../partitions/sql/pg/11_plus/partition_diff.sql | 8 ++-- .../partitions/sql/ppas/10_plus/attach.sql | 2 +- .../partitions/sql/ppas/10_plus/create.sql | 2 +- .../partitions/sql/ppas/10_plus/detach.sql | 2 +- .../partitions/sql/ppas/10_plus/partition_diff.sql | 8 ++-- .../row_security_policies/sql/9.5_plus/delete.sql | 2 +- .../row_security_policies/sql/default/delete.sql | 2 +- .../schemas/tables/templates/rules/sql/delete.sql | 2 +- .../tables/templates/tables/sql/10_plus/create.sql | 12 +++--- .../tables/templates/tables/sql/10_plus/update.sql | 40 +++++++++--------- .../tables/templates/tables/sql/11_plus/create.sql | 12 +++--- .../tables/templates/tables/sql/11_plus/update.sql | 48 +++++++++++----------- .../tables/templates/tables/sql/12_plus/create.sql | 12 +++--- .../tables/templates/tables/sql/12_plus/update.sql | 46 ++++++++++----------- .../templates/tables/sql/9.6_plus/create.sql | 12 +++--- .../templates/tables/sql/9.6_plus/update.sql | 42 +++++++++---------- .../tables/templates/tables/sql/default/create.sql | 12 +++--- .../tables/templates/tables/sql/default/delete.sql | 2 +- .../tables/templates/tables/sql/default/update.sql | 32 +++++++-------- .../templates/triggers/sql/pg/default/delete.sql | 2 +- .../templates/triggers/sql/ppas/default/delete.sql | 2 +- .../pg/10_plus/alter_table_with_toast_table.sql | 4 +- .../10_plus/alter_table_with_toast_table_msql.sql | 6 +-- .../pg/10_plus/create_table_with_partition.sql | 6 +-- .../10_plus/create_table_with_partition_msql.sql | 2 +- .../10_plus/create_table_with_range_partition.sql | 6 +-- .../create_table_with_range_partition_msql.sql | 2 +- .../pg/11_plus/alter_table_with_toast_table.sql | 4 +- .../11_plus/alter_table_with_toast_table_msql.sql | 6 +-- .../11_plus/create_table_with_hash_partition.sql | 6 +-- .../create_table_with_hash_partition_msql.sql | 2 +- .../pg/12_plus/alter_table_add_another_fk.sql | 4 +- .../pg/12_plus/alter_table_add_another_fk_msql.sql | 2 +- .../tests/pg/12_plus/alter_table_add_cols.sql | 4 +- .../tests/pg/12_plus/alter_table_add_cols_msql.sql | 4 +- .../12_plus/alter_table_add_exclude_constraint.sql | 4 +- .../alter_table_add_exclude_constraint_msql.sql | 2 +- .../alter_table_add_null_constraint_rename_col.sql | 4 +- ...r_table_add_null_constraint_rename_col_msql.sql | 4 +- .../tests/pg/12_plus/alter_table_add_partition.sql | 8 ++-- .../alter_table_add_pk_not_null_constraint.sql | 4 +- ...alter_table_add_pk_not_null_constraint_msql.sql | 4 +- .../pg/12_plus/alter_table_add_unique_const.sql | 4 +- .../12_plus/alter_table_add_unique_const_msql.sql | 2 +- .../12_plus/alter_table_change_col_data_type.sql | 4 +- .../tests/pg/12_plus/alter_table_delete_cols.sql | 4 +- .../pg/12_plus/alter_table_delete_cols_msql.sql | 2 +- .../pg/12_plus/alter_table_delete_constraints.sql | 4 +- .../alter_table_delete_constraints_msql.sql | 4 +- .../tests/pg/12_plus/alter_table_update_grants.sql | 4 +- .../pg/12_plus/alter_table_update_grants_msql.sql | 4 +- .../pg/12_plus/alter_table_with_toast_table.sql | 4 +- .../12_plus/alter_table_with_toast_table_msql.sql | 6 +-- .../12_plus/create_table_with_advanced_options.sql | 8 ++-- .../create_table_with_advanced_options_msql.sql | 6 +-- .../create_table_with_custom_autovacuum.sql | 4 +- .../create_table_with_custom_autovacuum_msql.sql | 2 +- .../tests/pg/12_plus/create_table_with_fk.sql | 4 +- .../tests/pg/12_plus/create_table_with_fk_msql.sql | 2 +- .../12_plus/create_table_with_hash_partition.sql | 6 +-- .../create_table_with_hash_partition_msql.sql | 2 +- .../tests/pg/12_plus/create_table_with_lik_tbl.sql | 4 +- .../pg/12_plus/create_table_with_lik_tbl_msql.sql | 2 +- .../pg/12_plus/create_table_with_partition.sql | 6 +-- .../12_plus/create_table_with_partition_msql.sql | 2 +- .../tests/pg/12_plus/create_table_with_pk.sql | 4 +- .../tests/pg/12_plus/create_table_with_pk_chk.sql | 4 +- .../pg/12_plus/create_table_with_pk_chk_msql.sql | 2 +- .../tests/pg/12_plus/create_table_with_pk_msql.sql | 2 +- .../12_plus/create_table_with_range_partition.sql | 6 +-- .../create_table_with_range_partition_msql.sql | 2 +- .../12_plus/create_table_without_primary_key.sql | 4 +- .../create_table_without_primary_key_msql.sql | 2 +- .../pg/default/alter_table_add_another_fk.sql | 4 +- .../pg/default/alter_table_add_another_fk_msql.sql | 2 +- .../tests/pg/default/alter_table_add_cols.sql | 4 +- .../tests/pg/default/alter_table_add_cols_msql.sql | 8 ++-- .../default/alter_table_add_exclude_constraint.sql | 4 +- .../alter_table_add_exclude_constraint_msql.sql | 2 +- .../alter_table_add_null_constraint_rename_col.sql | 4 +- ...r_table_add_null_constraint_rename_col_msql.sql | 4 +- .../alter_table_add_pk_not_null_constraint.sql | 4 +- ...alter_table_add_pk_not_null_constraint_msql.sql | 4 +- .../pg/default/alter_table_add_unique_const.sql | 4 +- .../default/alter_table_add_unique_const_msql.sql | 2 +- .../default/alter_table_change_col_data_type.sql | 4 +- .../tests/pg/default/alter_table_delete_cols.sql | 4 +- .../pg/default/alter_table_delete_cols_msql.sql | 2 +- .../pg/default/alter_table_delete_constraints.sql | 4 +- .../alter_table_delete_constraints_msql.sql | 4 +- .../tests/pg/default/alter_table_update_grants.sql | 4 +- .../pg/default/alter_table_update_grants_msql.sql | 4 +- .../pg/default/alter_table_with_toast_table.sql | 4 +- .../default/alter_table_with_toast_table_msql.sql | 6 +-- .../default/create_table_with_advanced_options.sql | 8 ++-- .../create_table_with_advanced_options_msql.sql | 6 +-- .../create_table_with_custom_autovacuum.sql | 4 +- .../create_table_with_custom_autovacuum_msql.sql | 2 +- .../tests/pg/default/create_table_with_fk.sql | 4 +- .../tests/pg/default/create_table_with_fk_msql.sql | 2 +- .../tests/pg/default/create_table_with_lik_tbl.sql | 4 +- .../pg/default/create_table_with_lik_tbl_msql.sql | 2 +- .../tests/pg/default/create_table_with_pk.sql | 4 +- .../tests/pg/default/create_table_with_pk_chk.sql | 4 +- .../pg/default/create_table_with_pk_chk_msql.sql | 2 +- .../tests/pg/default/create_table_with_pk_msql.sql | 2 +- .../default/create_table_without_primary_key.sql | 4 +- .../create_table_without_primary_key_msql.sql | 2 +- .../ppas/10_plus/alter_table_with_toast_table.sql | 4 +- .../10_plus/alter_table_with_toast_table_msql.sql | 6 +-- .../ppas/10_plus/create_table_with_partition.sql | 6 +-- .../10_plus/create_table_with_partition_msql.sql | 2 +- .../10_plus/create_table_with_range_partition.sql | 6 +-- .../create_table_with_range_partition_msql.sql | 2 +- .../ppas/11_plus/alter_table_with_toast_table.sql | 4 +- .../11_plus/alter_table_with_toast_table_msql.sql | 6 +-- .../11_plus/create_table_with_hash_partition.sql | 6 +-- .../create_table_with_hash_partition_msql.sql | 2 +- .../ppas/12_plus/alter_table_add_another_fk.sql | 4 +- .../12_plus/alter_table_add_another_fk_msql.sql | 2 +- .../tests/ppas/12_plus/alter_table_add_cols.sql | 4 +- .../ppas/12_plus/alter_table_add_cols_msql.sql | 4 +- .../12_plus/alter_table_add_exclude_constraint.sql | 4 +- .../alter_table_add_exclude_constraint_msql.sql | 2 +- .../alter_table_add_null_constraint_rename_col.sql | 4 +- ...r_table_add_null_constraint_rename_col_msql.sql | 4 +- .../ppas/12_plus/alter_table_add_partition.sql | 8 ++-- .../alter_table_add_pk_not_null_constraint.sql | 4 +- ...alter_table_add_pk_not_null_constraint_msql.sql | 4 +- .../ppas/12_plus/alter_table_add_unique_const.sql | 4 +- .../12_plus/alter_table_add_unique_const_msql.sql | 2 +- .../12_plus/alter_table_change_col_data_type.sql | 4 +- .../tests/ppas/12_plus/alter_table_delete_cols.sql | 4 +- .../ppas/12_plus/alter_table_delete_cols_msql.sql | 2 +- .../12_plus/alter_table_delete_constraints.sql | 4 +- .../alter_table_delete_constraints_msql.sql | 4 +- .../ppas/12_plus/alter_table_update_grants.sql | 4 +- .../12_plus/alter_table_update_grants_msql.sql | 4 +- .../ppas/12_plus/alter_table_with_toast_table.sql | 4 +- .../12_plus/alter_table_with_toast_table_msql.sql | 6 +-- .../12_plus/create_table_with_advanced_options.sql | 8 ++-- .../create_table_with_advanced_options_msql.sql | 6 +-- .../create_table_with_custom_autovacuum.sql | 4 +- .../create_table_with_custom_autovacuum_msql.sql | 2 +- .../tests/ppas/12_plus/create_table_with_fk.sql | 4 +- .../ppas/12_plus/create_table_with_fk_msql.sql | 2 +- .../12_plus/create_table_with_hash_partition.sql | 6 +-- .../create_table_with_hash_partition_msql.sql | 2 +- .../ppas/12_plus/create_table_with_lik_tbl.sql | 4 +- .../12_plus/create_table_with_lik_tbl_msql.sql | 2 +- .../ppas/12_plus/create_table_with_partition.sql | 6 +-- .../12_plus/create_table_with_partition_msql.sql | 2 +- .../tests/ppas/12_plus/create_table_with_pk.sql | 4 +- .../ppas/12_plus/create_table_with_pk_chk.sql | 4 +- .../ppas/12_plus/create_table_with_pk_chk_msql.sql | 2 +- .../ppas/12_plus/create_table_with_pk_msql.sql | 2 +- .../12_plus/create_table_with_range_partition.sql | 6 +-- .../create_table_with_range_partition_msql.sql | 2 +- .../12_plus/create_table_without_primary_key.sql | 4 +- .../create_table_without_primary_key_msql.sql | 2 +- .../ppas/default/alter_table_add_another_fk.sql | 4 +- .../default/alter_table_add_another_fk_msql.sql | 2 +- .../tests/ppas/default/alter_table_add_cols.sql | 4 +- .../ppas/default/alter_table_add_cols_msql.sql | 8 ++-- .../default/alter_table_add_exclude_constraint.sql | 4 +- .../alter_table_add_exclude_constraint_msql.sql | 2 +- .../alter_table_add_null_constraint_rename_col.sql | 4 +- ...r_table_add_null_constraint_rename_col_msql.sql | 4 +- .../alter_table_add_pk_not_null_constraint.sql | 4 +- ...alter_table_add_pk_not_null_constraint_msql.sql | 4 +- .../ppas/default/alter_table_add_unique_const.sql | 4 +- .../default/alter_table_add_unique_const_msql.sql | 2 +- .../default/alter_table_change_col_data_type.sql | 4 +- .../tests/ppas/default/alter_table_delete_cols.sql | 4 +- .../ppas/default/alter_table_delete_cols_msql.sql | 2 +- .../default/alter_table_delete_constraints.sql | 4 +- .../alter_table_delete_constraints_msql.sql | 4 +- .../ppas/default/alter_table_update_grants.sql | 4 +- .../default/alter_table_update_grants_msql.sql | 4 +- .../ppas/default/alter_table_with_toast_table.sql | 4 +- .../default/alter_table_with_toast_table_msql.sql | 6 +-- .../default/create_table_with_advanced_options.sql | 8 ++-- .../create_table_with_advanced_options_msql.sql | 6 +-- .../create_table_with_custom_autovacuum.sql | 4 +- .../create_table_with_custom_autovacuum_msql.sql | 2 +- .../tests/ppas/default/create_table_with_fk.sql | 4 +- .../ppas/default/create_table_with_fk_msql.sql | 2 +- .../ppas/default/create_table_with_lik_tbl.sql | 4 +- .../default/create_table_with_lik_tbl_msql.sql | 2 +- .../tests/ppas/default/create_table_with_pk.sql | 4 +- .../ppas/default/create_table_with_pk_chk.sql | 4 +- .../ppas/default/create_table_with_pk_chk_msql.sql | 2 +- .../ppas/default/create_table_with_pk_msql.sql | 2 +- .../default/create_table_without_primary_key.sql | 4 +- .../create_table_without_primary_key_msql.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- ...er_after_update_event_trigger_enable_always.sql | 2 +- ..._before_update_event_trigger_enable_replica.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- .../10_plus/create_after_update_event_trigger.sql | 2 +- .../10_plus/create_before_update_event_trigger.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- ...er_after_update_event_trigger_enable_always.sql | 2 +- .../11_plus/alter_before_insert_event_trigger.sql | 2 +- ..._before_update_event_trigger_enable_replica.sql | 2 +- .../11_plus/create_after_delete_event_trigger.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- .../11_plus/create_after_update_event_trigger.sql | 2 +- .../create_b4r_update_multiple_event_trigger.sql | 2 +- .../create_before_insert_event_at_statement.sql | 2 +- .../11_plus/create_before_insert_event_trigger.sql | 2 +- .../11_plus/create_before_update_event_trigger.sql | 2 +- ...er_after_update_event_trigger_enable_always.sql | 2 +- .../default/alter_before_insert_event_trigger.sql | 2 +- ..._before_update_event_trigger_enable_replica.sql | 2 +- .../default/create_after_delete_event_trigger.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- .../default/create_after_update_event_trigger.sql | 2 +- .../create_b4r_update_multiple_event_trigger.sql | 2 +- .../create_before_insert_event_at_statement.sql | 2 +- .../default/create_before_insert_event_trigger.sql | 2 +- .../default/create_before_update_event_trigger.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- ...er_after_update_event_trigger_enable_always.sql | 2 +- ..._before_update_event_trigger_enable_replica.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- .../10_plus/create_after_update_event_trigger.sql | 2 +- .../10_plus/create_before_update_event_trigger.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- ...er_after_update_event_trigger_enable_always.sql | 2 +- .../11_plus/alter_before_insert_event_trigger.sql | 2 +- ..._before_update_event_trigger_enable_replica.sql | 2 +- .../11_plus/create_after_delete_event_trigger.sql | 2 +- ..._after_delete_event_trigger_with_transition.sql | 2 +- ..._after_insert_event_trigger_with_transition.sql | 2 +- .../11_plus/create_after_update_event_trigger.sql | 2 +- .../create_b4r_update_multiple_event_trigger.sql | 2 +- .../create_before_insert_event_at_statement.sql | 2 +- .../11_plus/create_before_insert_event_trigger.sql | 2 +- .../11_plus/create_before_update_event_trigger.sql | 2 +- ...er_after_update_event_trigger_enable_always.sql | 2 +- .../default/alter_before_insert_event_trigger.sql | 2 +- ..._before_update_event_trigger_enable_replica.sql | 2 +- .../default/create_after_delete_event_trigger.sql | 2 +- .../default/create_after_update_event_trigger.sql | 2 +- .../create_b4r_update_multiple_event_trigger.sql | 2 +- .../create_before_insert_event_at_statement.sql | 2 +- .../default/create_before_insert_event_trigger.sql | 2 +- .../default/create_before_update_event_trigger.sql | 2 +- .../templates/types/pg/sql/default/delete.sql | 2 +- .../templates/types/ppas/sql/default/delete.sql | 2 +- .../tests/pg/default/alter_acl_grantee_change.sql | 2 +- .../alter_composite_type_acl_description.sql | 2 +- .../pg/default/alter_composite_type_add_member.sql | 2 +- .../default/alter_composite_type_remove_member.sql | 2 +- .../pg/default/alter_enum_type_acl_description.sql | 2 +- .../tests/pg/default/alter_enum_type_label.sql | 2 +- .../default/alter_range_type_acl_description.sql | 2 +- .../default/alter_shell_type_acl_description.sql | 2 +- .../tests/pg/default/create_composite_type.sql | 2 +- .../pg/default/create_composite_type_one_field.sql | 2 +- .../types/tests/pg/default/create_enum_type.sql | 2 +- .../types/tests/pg/default/create_range_type.sql | 2 +- .../types/tests/pg/default/create_shell_type.sql | 2 +- .../ppas/default/alter_acl_grantee_change.sql | 2 +- .../alter_composite_type_acl_description.sql | 2 +- .../default/alter_composite_type_add_member.sql | 2 +- .../default/alter_composite_type_remove_member.sql | 2 +- .../default/alter_enum_type_acl_description.sql | 2 +- .../tests/ppas/default/alter_enum_type_label.sql | 2 +- .../default/alter_range_type_acl_description.sql | 2 +- .../default/alter_shell_type_acl_description.sql | 2 +- .../tests/ppas/default/create_composite_type.sql | 2 +- .../default/create_composite_type_one_field.sql | 2 +- .../types/tests/ppas/default/create_enum_type.sql | 2 +- .../ppas/default/create_nested_table_type.sql | 2 +- .../types/tests/ppas/default/create_range_type.sql | 2 +- .../types/tests/ppas/default/create_shell_type.sql | 2 +- .../tests/ppas/default/create_varray_type.sql | 2 +- .../templates/mviews/pg/9.3_plus/sql/create.sql | 4 +- .../templates/mviews/pg/9.3_plus/sql/delete.sql | 2 +- .../templates/mviews/pg/9.3_plus/sql/update.sql | 24 +++++------ .../templates/mviews/pg/9.4_plus/sql/create.sql | 4 +- .../templates/mviews/pg/9.4_plus/sql/delete.sql | 2 +- .../templates/mviews/pg/9.4_plus/sql/update.sql | 24 +++++------ .../templates/mviews/ppas/9.3_plus/sql/create.sql | 4 +- .../templates/mviews/ppas/9.3_plus/sql/delete.sql | 2 +- .../templates/mviews/ppas/9.3_plus/sql/update.sql | 24 +++++------ .../templates/views/pg/9.3_plus/sql/delete.sql | 2 +- .../templates/views/pg/9.4_plus/sql/delete.sql | 2 +- .../templates/views/ppas/9.3_plus/sql/create.sql | 2 +- .../templates/views/ppas/9.3_plus/sql/delete.sql | 2 +- .../templates/views/ppas/9.3_plus/sql/update.sql | 8 ++-- .../templates/views/ppas/9.4_plus/sql/create.sql | 2 +- .../templates/views/ppas/9.4_plus/sql/delete.sql | 2 +- .../templates/views/ppas/9.4_plus/sql/update.sql | 12 +++--- .../views/tests/pg/9.4_plus/alter_mview.sql | 4 +- .../pg/9.4_plus/alter_mview_add_fillfactor.sql | 4 +- .../9.4_plus/alter_mview_add_fillfactor_msql.sql | 2 +- .../9.4_plus/alter_mview_add_table_parameter.sql | 4 +- .../alter_mview_add_table_parameter_msql.sql | 2 +- .../9.4_plus/alter_mview_change_grantee_priv.sql | 4 +- .../tests/pg/9.4_plus/alter_mview_definition.sql | 4 +- .../pg/9.4_plus/alter_mview_definition_msql.sql | 4 +- .../pg/9.4_plus/alter_mview_drop_all_priv.sql | 4 +- .../alter_mview_remove_table_parameter.sql | 4 +- .../alter_mview_remove_table_parameter_msql.sql | 2 +- .../views/tests/pg/9.4_plus/create_mview.sql | 4 +- .../views/tests/pg/9.4_plus/create_mview_msql.sql | 4 +- .../views/tests/ppas/9.4_plus/alter_mview.sql | 4 +- .../ppas/9.4_plus/alter_mview_add_fillfactor.sql | 4 +- .../9.4_plus/alter_mview_add_fillfactor_msql.sql | 2 +- .../9.4_plus/alter_mview_add_table_parameter.sql | 4 +- .../alter_mview_add_table_parameter_msql.sql | 2 +- .../9.4_plus/alter_mview_change_grantee_priv.sql | 4 +- .../tests/ppas/9.4_plus/alter_mview_definition.sql | 4 +- .../ppas/9.4_plus/alter_mview_definition_msql.sql | 4 +- .../ppas/9.4_plus/alter_mview_drop_all_priv.sql | 4 +- .../alter_mview_remove_table_parameter.sql | 4 +- .../alter_mview_remove_table_parameter_msql.sql | 2 +- .../views/tests/ppas/9.4_plus/alter_view.sql | 2 +- .../ppas/9.4_plus/alter_view_add_some_priv.sql | 2 +- .../tests/ppas/9.4_plus/alter_view_delete_priv.sql | 2 +- .../views/tests/ppas/9.4_plus/alter_view_msql.sql | 4 +- .../tests/ppas/9.4_plus/alter_view_update_priv.sql | 2 +- .../views/tests/ppas/9.4_plus/create_mview.sql | 4 +- .../tests/ppas/9.4_plus/create_mview_msql.sql | 4 +- .../views/tests/ppas/9.4_plus/create_view.sql | 2 +- .../views/tests/ppas/9.4_plus/create_view_msql.sql | 2 +- .../templates/subscriptions/sql/default/delete.sql | 2 +- .../templates/databases/sql/9.6_plus/delete.sql | 8 ++++ .../templates/tablespaces/sql/default/delete.sql | 2 +- .../erd/tests/sql/12_plus/test_sql_output.sql | 2 +- .../erd/tests/sql/default/test_sql_output.sql | 2 +- 795 files changed, 1647 insertions(+), 1597 deletions(-)
