Remove the SQL files for the unsupported versions of the database server. Fixes #7462 Fixed API test cases for Postgres 14.4. Fixes #7527
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=8c24d28740984757fd4cff0898d7ca541ba557a5 Author: Pradip Parkale <pradip.park...@enterprisedb.com> Modified Files -------------- docs/en_US/release_notes_6_13.rst | 2 + .../servers/databases/event_triggers/__init__.py | 3 +- .../sql/{9.3_plus => default}/create.sql | 0 .../sql/{9.3_plus => default}/delete.sql | 0 .../sql/{9.3_plus => default}/eventfunctions.sql | 0 .../sql/{9.3_plus => default}/get_db.sql | 0 .../sql/{9.3_plus => default}/get_oid.sql | 0 .../sql/{9.3_plus => default}/grant.sql | 0 .../sql/{9.3_plus => default}/nodes.sql | 0 .../sql/{9.3_plus => default}/properties.sql | 0 .../sql/{9.3_plus => default}/update.sql | 0 .../tests/9.4_plus/alter_extension_schema.sql | 7 - .../tests/9.4_plus/alter_extension_version.sql | 7 - .../9.4_plus/create_extension_with_all_options.sql | 7 - .../create_extension_with_default_schema.sql | 7 - .../9.4_plus/msql_alter_extension_version.sql | 2 - .../msql_create_extension_with_all_options.sql | 3 - .../msql_create_extension_with_default_schema.sql | 2 - .../databases/extensions/tests/9.4_plus/tests.json | 73 - .../tests/9.5_plus/alter_extension_schema.sql | 7 - .../9.5_plus/create_extension_with_all_options.sql | 7 - .../tests/9.5_plus/msql_alter_extension_schema.sql | 2 - .../msql_create_extension_with_all_options.sql | 3 - .../databases/extensions/tests/9.5_plus/tests.json | 39 - .../tests/9.6_plus/msql_alter_extension_schema.sql | 2 - .../alter_extension_schema.sql | 0 .../alter_extension_version.sql | 0 .../create_extension_with_all_options.sql | 0 .../create_extension_with_default_schema.sql | 0 .../msql_alter_extension_schema.sql | 0 .../msql_alter_extension_version.sql | 0 .../msql_create_extension_with_all_options.sql | 0 .../msql_create_extension_with_default_schema.sql | 0 .../tests/{9.6_plus => default}/tests.json | 0 .../templates/foreign_servers/sql/9.3_plus/acl.sql | 22 - .../foreign_servers/sql/9.3_plus/create.sql | 33 - .../foreign_servers/sql/9.3_plus/properties.sql | 30 - .../templates/foreign_servers/sql/default/acl.sql | 11 +- .../foreign_servers/sql/default/create.sql | 3 +- .../foreign_servers/sql/default/properties.sql | 11 +- .../alter_comment_version.sql | 0 .../alter_comment_version_msql.sql | 0 .../alter_options_privileges.sql | 0 .../alter_options_privileges_msql.sql | 0 .../alter_remove_options_priv.sql | 0 .../alter_remove_options_priv_msql.sql | 0 .../create_fs_all_options.sql | 0 .../create_fs_all_options_msql.sql | 0 .../test_foreign_servers.json | 0 .../alter_comment_version.sql | 0 .../alter_comment_version_msql.sql | 0 .../alter_options_privileges.sql | 0 .../alter_options_privileges_msql.sql | 0 .../alter_remove_options_priv.sql | 0 .../alter_remove_options_priv_msql.sql | 0 .../create_fs_all_options.sql | 0 .../create_fs_all_options_msql.sql | 0 .../test_foreign_servers.json | 0 .../foreign_data_wrappers/sql/9.3_plus/acl.sql | 22 - .../foreign_data_wrappers/sql/9.3_plus/create.sql | 31 - .../sql/9.3_plus/properties.sql | 30 - .../foreign_data_wrappers/sql/9.3_plus/update.sql | 86 - .../foreign_data_wrappers/sql/default/acl.sql | 10 +- .../foreign_data_wrappers/sql/default/create.sql | 3 +- .../sql/default/properties.sql | 14 +- .../foreign_data_wrappers/sql/default/update.sql | 5 +- .../templates/languages/sql/9.3_plus/acl.sql | 20 - .../templates/languages/sql/9.3_plus/sqlpane.sql | 42 - .../templates/languages/sql/default/acl.sql | 6 +- .../{10_plus => default}/alter_publication.sql | 0 .../alter_publication_event.sql | 0 .../alter_publication_event_msql.sql | 0 .../alter_publication_msql.sql | 0 .../{10_plus => default}/create_publication.sql | 0 .../create_publication_msql.sql | 0 .../create_publication_update.sql | 0 .../create_publication_update_msql.sql | 0 .../tests/{10_plus => default}/test.json | 0 .../templates/collations/sql/10_plus/create.sql | 25 - .../templates/collations/sql/default/create.sql | 5 - .../sql/default/get_type_category.sql | 5 + .../templates/domains/sql/9.2_plus/create.sql | 41 - .../domains/sql/9.2_plus/get_collations.sql | 10 - .../domains/sql/9.2_plus/get_constraints.sql | 15 - .../templates/domains/sql/9.2_plus/node.sql | 21 - .../templates/domains/sql/9.2_plus/properties.sql | 34 - .../templates/domains/sql/9.2_plus/update.sql | 100 - .../templates/domains/sql/default/create.sql | 27 +- .../{9.2_plus => default}/domain_schema_diff.sql | 0 .../domains/sql/default/get_collations.sql | 2 +- .../domains/sql/default/get_constraints.sql | 8 +- .../domains/templates/domains/sql/default/node.sql | 6 +- .../templates/domains/sql/default/properties.sql | 9 +- .../templates/domains/sql/default/update.sql | 53 +- .../foreign_tables/sql/9.2_plus/create.sql | 47 - .../foreign_tables/sql/9.2_plus/delete.sql | 17 - .../foreign_tables/sql/9.2_plus/get_collations.sql | 9 - .../foreign_tables/sql/9.2_plus/get_columns.sql | 25 - .../sql/9.2_plus/get_constraints.sql | 7 - .../sql/9.2_plus/get_foreign_servers.sql | 6 - .../foreign_tables/sql/9.2_plus/properties.sql | 27 - .../foreign_tables/sql/9.2_plus/update.sql | 172 -- .../foreign_tables/sql/9.5_plus/create.sql | 64 - .../foreign_tables/sql/9.5_plus/get_columns.sql | 43 - .../sql/9.5_plus/get_constraints.sql | 7 - .../sql/9.5_plus/get_foreign_servers.sql | 6 - .../foreign_tables/sql/9.5_plus/properties.sql | 31 - .../foreign_tables/sql/9.5_plus/update.sql | 216 --- .../sql/{9.2_plus => default}/acl.sql | 0 .../foreign_tables/sql/default/create.sql | 36 +- .../foreign_table_schema_diff.sql | 0 .../foreign_tables/sql/default/get_columns.sql | 37 +- .../foreign_tables/sql/default/get_constraints.sql | 2 +- .../sql/default/get_foreign_servers.sql | 3 +- .../{9.5_plus => default}/get_table_columns.sql | 0 .../sql/{9.5_plus => default}/get_tables.sql | 0 .../foreign_tables/sql/default/properties.sql | 10 +- .../foreign_tables/sql/default/update.sql | 173 +- .../tests/pg/9.2_plus/alter_add_opts.sql | 16 - .../tests/pg/9.2_plus/alter_add_opts_msql.sql | 5 - .../tests/pg/9.2_plus/alter_add_priv.sql | 20 - .../tests/pg/9.2_plus/alter_col_opts.sql | 19 - .../tests/pg/9.2_plus/alter_col_opts_msql.sql | 14 - .../pg/9.2_plus/alter_comment_add_columns.sql | 15 - .../pg/9.2_plus/alter_comment_add_columns_msql.sql | 8 - .../tests/pg/9.2_plus/alter_remove_opts_priv.sql | 17 - .../pg/9.2_plus/alter_remove_opts_priv_msql.sql | 4 - .../create_foreign_table_with_all_options.sql | 20 - .../create_foreign_table_with_all_options_msql.sql | 14 - .../tests/pg/9.2_plus/test_foreign_table.json | 238 --- .../{9.6_plus => default}/alter_add_cons_opts.sql | 0 .../alter_add_cons_opts_msql.sql | 0 .../pg/{9.6_plus => default}/alter_add_priv.sql | 0 .../{9.2_plus => default}/alter_add_priv_msql.sql | 0 .../pg/{9.6_plus => default}/alter_col_opts.sql | 0 .../{9.6_plus => default}/alter_col_opts_msql.sql | 0 .../alter_comment_add_columns.sql | 0 .../alter_comment_add_columns_msql.sql | 0 .../alter_remove_opts_priv_cons.sql | 0 .../alter_remove_opts_priv_cons_msql.sql | 0 .../create_foreign_table_with_all_options.sql | 0 .../create_foreign_table_with_all_options_msql.sql | 0 .../{9.6_plus => default}/test_foreign_table.json | 0 .../tests/ppas/9.2_plus/alter_add_priv.sql | 21 - .../tests/ppas/9.2_plus/alter_add_priv_msql.sql | 1 - .../tests/ppas/9.2_plus/alter_column.sql | 20 - .../tests/ppas/9.2_plus/alter_column_msql.sql | 11 - .../ppas/9.2_plus/alter_comment_add_columns.sql | 17 - .../9.2_plus/alter_comment_add_columns_msql.sql | 8 - .../tests/ppas/9.2_plus/alter_remove_priv.sql | 18 - .../tests/ppas/9.2_plus/alter_remove_priv_msql.sql | 1 - .../create_foreign_table_with_all_options.sql | 19 - .../create_foreign_table_with_all_options_msql.sql | 13 - .../tests/ppas/9.2_plus/test_foreign_table.json | 225 --- .../tests/ppas/9.6_plus/alter_add_priv_msql.sql | 1 - .../{9.6_plus => default}/alter_add_cons_opts.sql | 0 .../alter_add_cons_opts_msql.sql | 0 .../ppas/{9.6_plus => default}/alter_add_priv.sql | 0 .../default}/alter_add_priv_msql.sql | 0 .../ppas/{9.6_plus => default}/alter_col_opts.sql | 0 .../{9.6_plus => default}/alter_col_opts_msql.sql | 0 .../alter_comment_add_columns.sql | 0 .../alter_comment_add_columns_msql.sql | 0 .../alter_remove_opts_priv_cons.sql | 0 .../alter_remove_opts_priv_cons_msql.sql | 0 .../create_foreign_table_with_all_options.sql | 0 .../create_foreign_table_with_all_options_msql.sql | 0 .../{9.6_plus => default}/test_foreign_table.json | 0 .../templates/functions/pg/sql/9.2_plus/create.sql | 67 - .../functions/pg/sql/9.2_plus/properties.sql | 35 - .../templates/functions/pg/sql/9.2_plus/update.sql | 120 -- .../templates/functions/pg/sql/9.5_plus/create.sql | 66 - .../functions/pg/sql/9.5_plus/properties.sql | 35 - .../templates/functions/pg/sql/9.5_plus/update.sql | 120 -- .../templates/functions/pg/sql/9.6_plus/create.sql | 70 - .../templates/functions/pg/sql/9.6_plus/delete.sql | 21 - .../functions/pg/sql/9.6_plus/properties.sql | 35 - .../templates/functions/pg/sql/9.6_plus/update.sql | 122 -- .../templates/functions/pg/sql/default/create.sql | 22 +- .../templates/functions/pg/sql/default/delete.sql | 2 +- .../functions/pg/sql/default/properties.sql | 2 +- .../templates/functions/pg/sql/default/update.sql | 41 +- .../functions/ppas/sql/9.2_plus/create.sql | 67 - .../functions/ppas/sql/9.2_plus/delete.sql | 22 - .../functions/ppas/sql/9.2_plus/get_oid.sql | 17 - .../functions/ppas/sql/9.2_plus/update.sql | 120 -- .../functions/ppas/sql/9.5_plus/create.sql | 64 - .../functions/ppas/sql/9.5_plus/delete.sql | 21 - .../functions/ppas/sql/9.5_plus/update.sql | 120 -- .../functions/ppas/sql/9.6_plus/create.sql | 70 - .../functions/ppas/sql/9.6_plus/delete.sql | 21 - .../functions/ppas/sql/9.6_plus/properties.sql | 35 - .../functions/ppas/sql/9.6_plus/update.sql | 122 -- .../functions/ppas/sql/default/create.sql | 22 +- .../functions/ppas/sql/default/delete.sql | 2 +- .../functions/ppas/sql/default/properties.sql | 2 +- .../functions/ppas/sql/default/update.sql | 47 +- .../procedures/ppas/sql/9.2_plus/create.sql | 42 - .../procedures/ppas/sql/9.2_plus/update.sql | 78 - .../procedures/ppas/sql/9.5_plus/create.sql | 52 - .../procedures/ppas/sql/9.5_plus/update.sql | 106 -- .../procedures/ppas/sql/9.6_plus/create.sql | 60 - .../procedures/ppas/sql/9.6_plus/properties.sql | 46 - .../procedures/ppas/sql/9.6_plus/update.sql | 109 -- .../procedures/ppas/sql/default/create.sql | 17 +- .../procedures/ppas/sql/default/properties.sql | 2 +- .../procedures/ppas/sql/default/update.sql | 43 +- .../trigger_functions/pg/sql/9.2_plus/create.sql | 57 - .../trigger_functions/pg/sql/9.2_plus/delete.sql | 21 - .../trigger_functions/pg/sql/9.2_plus/get_oid.sql | 18 - .../trigger_functions/pg/sql/9.2_plus/node.sql | 27 - .../pg/sql/9.2_plus/properties.sql | 36 - .../trigger_functions/pg/sql/9.2_plus/update.sql | 114 -- .../trigger_functions/pg/sql/9.5_plus/create.sql | 57 - .../trigger_functions/pg/sql/9.5_plus/node.sql | 27 - .../trigger_functions/pg/sql/9.5_plus/update.sql | 114 -- .../trigger_functions/pg/sql/default/create.sql | 11 +- .../trigger_functions/pg/sql/default/delete.sql | 2 +- .../trigger_functions/pg/sql/default/get_oid.sql | 3 +- .../trigger_functions/pg/sql/default/node.sql | 7 +- .../trigger_functions/pg/sql/default/update.sql | 36 +- .../trigger_functions/ppas/sql/9.2_plus/create.sql | 58 - .../trigger_functions/ppas/sql/9.2_plus/delete.sql | 22 - .../ppas/sql/9.2_plus/get_oid.sql | 18 - .../trigger_functions/ppas/sql/9.2_plus/node.sql | 27 - .../ppas/sql/9.2_plus/properties.sql | 36 - .../trigger_functions/ppas/sql/9.2_plus/update.sql | 110 -- .../trigger_functions/ppas/sql/9.5_plus/create.sql | 57 - .../trigger_functions/ppas/sql/9.5_plus/delete.sql | 21 - .../trigger_functions/ppas/sql/9.5_plus/update.sql | 110 -- .../trigger_functions/ppas/sql/default/create.sql | 9 +- .../trigger_functions/ppas/sql/default/delete.sql | 2 +- .../trigger_functions/ppas/sql/default/get_oid.sql | 3 +- .../trigger_functions/ppas/sql/default/node.sql | 7 +- .../trigger_functions/ppas/sql/default/update.sql | 39 +- .../tests/pg/9.5_plus/alter_function_add_acl.sql | 26 - .../pg/9.5_plus/alter_function_add_parameter.msql | 12 - .../pg/9.5_plus/alter_function_add_parameter.sql | 20 - .../9.5_plus/alter_function_change_grantee_acl.sql | 21 - .../tests/pg/9.5_plus/alter_function_comment.sql | 22 - .../pg/9.5_plus/alter_function_delete_acl.sql | 19 - .../9.5_plus/alter_function_delete_parameter.sql | 19 - .../tests/pg/9.5_plus/alter_function_rename.sql | 19 - .../tests/pg/9.5_plus/alter_ptrig_comment.sql | 20 - .../tests/pg/9.5_plus/alter_ptrig_set_1.sql | 20 - .../tests/pg/9.5_plus/alter_ptrig_set_2.sql | 22 - .../tests/pg/9.5_plus/alter_ptrig_set_3.sql | 23 - .../pg/9.5_plus/create_event_trigger_full.sql | 26 - .../tests/pg/9.5_plus/create_function.msql | 14 - .../tests/pg/9.5_plus/create_function.sql | 20 - .../pg/9.5_plus/create_function_for_alter.msql | 14 - .../pg/9.5_plus/create_function_for_alter.sql | 19 - .../tests/pg/9.5_plus/create_plain_trigger.sql | 17 - .../pg/9.5_plus/create_plain_trigger_full.sql | 27 - .../functions/tests/pg/9.5_plus/test_function.json | 310 --- .../tests/pg/9.5_plus/test_trigger_functions.json | 191 -- .../tests/pg/9.6_plus/alter_function_add_acl.msql | 1 - .../alter_function_change_grantee_acl.msql | 3 - .../pg/9.6_plus/alter_function_delete_acl.msql | 3 - .../tests/pg/9.6_plus/alter_ptrig_comment.sql | 20 - .../tests/pg/9.6_plus/alter_ptrig_set_1.sql | 20 - .../tests/pg/9.6_plus/alter_ptrig_set_2.sql | 22 - .../tests/pg/9.6_plus/alter_ptrig_set_3.sql | 23 - .../pg/9.6_plus/create_event_trigger_full.sql | 26 - .../tests/pg/9.6_plus/create_plain_trigger.sql | 17 - .../pg/9.6_plus/create_plain_trigger_full.sql | 27 - .../tests/pg/9.6_plus/test_trigger_functions.json | 191 -- .../alter_function_add_acl.msql | 0 .../alter_function_add_acl.sql | 0 .../alter_function_add_parameter.msql | 0 .../alter_function_add_parameter.sql | 0 .../alter_function_change_grantee_acl.msql | 0 .../alter_function_change_grantee_acl.sql | 0 .../alter_function_comment.msql | 0 .../alter_function_comment.sql | 0 .../alter_function_delete_acl.msql | 0 .../alter_function_delete_acl.sql | 0 .../alter_function_delete_parameter.msql | 0 .../alter_function_delete_parameter.sql | 0 .../alter_function_rename.msql | 0 .../alter_function_rename.sql | 0 .../tests/pg/default/alter_ptrig_comment.sql | 2 +- .../tests/pg/default/alter_ptrig_set_1.sql | 2 +- .../tests/pg/default/alter_ptrig_set_2.sql | 2 +- .../tests/pg/default/alter_ptrig_set_3.sql | 2 +- .../tests/pg/default/create_event_trigger_full.sql | 2 +- .../pg/{9.6_plus => default}/create_function.msql | 0 .../pg/{9.6_plus => default}/create_function.sql | 0 .../create_function_for_alter.msql | 0 .../create_function_for_alter.sql | 0 .../tests/pg/default/create_plain_trigger.sql | 2 +- .../tests/pg/default/create_plain_trigger_full.sql | 2 +- .../pg/{9.6_plus => default}/test_function.json | 0 .../tests/ppas/9.5_plus/alter_function_add_acl.sql | 24 - .../ppas/9.5_plus/alter_function_add_parameter.sql | 20 - .../9.5_plus/alter_function_change_grantee_acl.sql | 21 - .../ppas/9.5_plus/alter_function_comment.msql | 2 - .../tests/ppas/9.5_plus/alter_function_comment.sql | 22 - .../ppas/9.5_plus/alter_function_delete_acl.sql | 19 - .../9.5_plus/alter_function_delete_parameter.msql | 2 - .../9.5_plus/alter_function_delete_parameter.sql | 19 - .../tests/ppas/9.5_plus/alter_function_rename.msql | 2 - .../tests/ppas/9.5_plus/alter_function_rename.sql | 19 - .../tests/ppas/9.5_plus/create_function.msql | 14 - .../tests/ppas/9.5_plus/create_function.sql | 19 - .../ppas/9.5_plus/create_function_for_alter.msql | 14 - .../ppas/9.5_plus/create_function_for_alter.sql | 19 - .../tests/ppas/9.5_plus/test_function.json | 322 ---- .../ppas/9.6_plus/alter_function_add_acl.msql | 3 - .../9.6_plus/alter_function_add_parameter.msql | 13 - .../alter_function_change_grantee_acl.msql | 3 - .../ppas/9.6_plus/alter_function_comment.msql | 2 - .../ppas/9.6_plus/alter_function_delete_acl.msql | 3 - .../9.6_plus/alter_function_delete_parameter.msql | 2 - .../tests/ppas/9.6_plus/alter_function_rename.msql | 2 - .../tests/ppas/9.6_plus/alter_proc_comment.sql | 17 - .../ppas/9.6_plus/alter_proc_comment_msql.sql | 2 - .../tests/ppas/9.6_plus/alter_proc_opt.sql | 18 - .../tests/ppas/9.6_plus/alter_proc_opt_msql.sql | 15 - .../tests/ppas/9.6_plus/alter_proc_param.sql | 18 - .../tests/ppas/9.6_plus/alter_proc_param_msql.sql | 2 - .../tests/ppas/9.6_plus/alter_ptrig_comment.sql | 20 - .../tests/ppas/9.6_plus/alter_ptrig_set_1.sql | 20 - .../tests/ppas/9.6_plus/alter_ptrig_set_2.sql | 22 - .../tests/ppas/9.6_plus/alter_ptrig_set_3.sql | 23 - .../ppas/9.6_plus/create_event_trigger_full.sql | 22 - .../tests/ppas/9.6_plus/create_plain_trigger.sql | 17 - .../ppas/9.6_plus/create_plain_trigger_full.sql | 23 - .../tests/ppas/9.6_plus/create_procedure.sql | 14 - .../tests/ppas/9.6_plus/test_procedures.json | 122 -- .../ppas/9.6_plus/test_trigger_functions.json | 171 -- .../alter_function_add_acl.msql | 0 .../alter_function_add_acl.sql | 0 .../alter_function_add_parameter.msql | 0 .../alter_function_add_parameter.sql | 0 .../alter_function_change_grantee_acl.msql | 0 .../alter_function_change_grantee_acl.sql | 0 .../default}/alter_function_comment.msql | 0 .../alter_function_comment.sql | 0 .../alter_function_delete_acl.msql | 0 .../alter_function_delete_acl.sql | 0 .../default}/alter_function_delete_parameter.msql | 0 .../alter_function_delete_parameter.sql | 0 .../default}/alter_function_rename.msql | 0 .../alter_function_rename.sql | 0 .../alter_proc_change_grantee_priv.msql | 0 .../alter_proc_change_grantee_priv.sql | 0 .../tests/ppas/default/alter_proc_comment.sql | 6 +- .../tests/ppas/default/alter_proc_opt.sql | 6 +- .../tests/ppas/default/alter_proc_opt_msql.sql | 2 +- .../tests/ppas/default/alter_proc_param.sql | 6 +- .../{9.6_plus => default}/create_function.msql | 0 .../ppas/{9.6_plus => default}/create_function.sql | 0 .../create_function_for_alter.msql | 0 .../create_function_for_alter.sql | 0 .../tests/ppas/default/create_plain_trigger.sql | 2 +- .../ppas/default/create_plain_trigger_full.sql | 2 +- .../tests/ppas/default/create_procedure.sql | 6 +- .../ppas/{9.6_plus => default}/test_function.json | 0 .../tests/ppas/default/test_procedures.json | 67 +- .../tests/ppas/default/test_trigger_functions.json | 2 +- .../templates/packages/ppas/9.1_plus/acl.sql | 33 - .../templates/packages/ppas/9.1_plus/create.sql | 24 - .../templates/packages/ppas/9.1_plus/get_oid.sql | 4 - .../templates/packages/ppas/9.1_plus/nodes.sql | 13 - .../packages/ppas/9.1_plus/properties.sql | 17 - .../templates/packages/ppas/9.2_plus/delete.sql | 1 - .../packages/ppas/9.2_plus/get_schema.sql | 6 - .../templates/packages/ppas/9.2_plus/grant.sql | 26 - .../templates/packages/ppas/9.2_plus/update.sql | 48 - .../packages/ppas/{9.2_plus => default}/acl.sql | 0 .../packages/ppas/{9.2_plus => default}/create.sql | 0 .../packages/ppas/{9.1_plus => default}/delete.sql | 0 .../ppas/{9.2_plus => default}/get_oid.sql | 0 .../ppas/{9.1_plus => default}/get_schema.sql | 0 .../packages/ppas/{9.1_plus => default}/grant.sql | 0 .../packages/ppas/{9.2_plus => default}/nodes.sql | 0 .../ppas/{9.2_plus => default}/properties.sql | 0 .../packages/ppas/{9.1_plus => default}/update.sql | 0 .../9.2_plus/alter_package_headers_and_comment.sql | 21 - .../alter_package_headers_and_comment_msql.sql | 4 - .../9.2_plus/create_package_with_all_options.sql | 23 - .../create_package_with_all_options_msql.sql | 17 - .../schemas/packages/tests/ppas/9.2_plus/test.json | 65 - .../alter_package_headers_and_comment.sql | 0 .../alter_package_headers_and_comment_msql.sql | 0 .../create_package_with_all_options.sql | 0 .../create_package_with_all_options_msql.sql | 0 .../tests/ppas/{10_plus => default}/test.json | 0 .../templates/sequences/sql/10_plus/get_def.sql | 11 - .../templates/sequences/sql/default/get_def.sql | 19 +- .../synonyms/sql/9.2_plus/get_objects.sql | 56 - .../templates/synonyms/sql/9.2_plus/properties.sql | 34 - .../synonyms/sql/9.5_plus/get_objects.sql | 56 - .../templates/synonyms/sql/9.5_plus/properties.sql | 34 - .../templates/synonyms/sql/default/get_objects.sql | 13 + .../sql/{9.5_plus => default}/get_schema.sql | 0 .../templates/synonyms/sql/default/properties.sql | 18 +- .../pg/10_plus/alter_column_alt_privilege.msql | 2 - .../pg/10_plus/alter_column_alt_privilege.sql | 13 - .../tests/pg/10_plus/alter_column_char.msql | 15 - .../columns/tests/pg/10_plus/alter_column_char.sql | 17 - .../columns/tests/pg/10_plus/alter_column_int.msql | 9 - .../columns/tests/pg/10_plus/alter_column_int.sql | 11 - .../tests/pg/10_plus/alter_column_numeric.msql | 9 - .../tests/pg/10_plus/alter_column_numeric.sql | 15 - .../pg/10_plus/alter_column_remove_length.msql | 2 - .../pg/10_plus/alter_column_remove_length.sql | 15 - .../tests/pg/10_plus/create_column_char.msql | 5 - .../tests/pg/10_plus/create_column_char.sql | 9 - .../tests/pg/10_plus/create_column_int.msql | 5 - .../columns/tests/pg/10_plus/create_column_int.sql | 9 - .../tests/pg/10_plus/create_column_numeric.msql | 9 - .../tests/pg/10_plus/create_column_numeric.sql | 13 - .../tables/columns/tests/pg/10_plus/test.json | 698 ------- .../pg/default/alter_column_alt_privilege.msql | 4 +- .../pg/default/alter_column_alt_privilege.sql | 12 +- .../tests/pg/default/alter_column_char.msql | 12 +- .../columns/tests/pg/default/alter_column_char.sql | 14 +- .../alter_column_drop_identity.msql | 0 .../alter_column_drop_identity.sql | 0 .../alter_column_drop_identity_by_default.msql | 0 .../alter_column_drop_identity_by_default.sql | 0 .../alter_column_identity.msql | 0 .../{10_plus => default}/alter_column_identity.sql | 0 .../alter_column_identity_by_default.msql | 0 .../alter_column_identity_by_default.sql | 0 .../alter_column_identity_for_comb_start_seq.msql | 0 .../alter_column_identity_for_comb_start_seq.sql | 0 .../alter_column_identity_for_restart_seq.msql | 0 .../alter_column_identity_for_restart_seq.sql | 0 .../columns/tests/pg/default/alter_column_int.msql | 8 +- .../columns/tests/pg/default/alter_column_int.sql | 10 +- .../tests/pg/default/alter_column_numeric.msql | 12 +- .../tests/pg/default/alter_column_numeric.sql | 16 +- .../pg/default/alter_column_remove_length.msql | 4 +- .../pg/default/alter_column_remove_length.sql | 16 +- .../alter_column_text_with_default_value.msql | 0 .../alter_column_text_with_default_value.sql | 0 ...imestamp_with_default_value_using_function.msql | 0 ...timestamp_with_default_value_using_function.sql | 0 ...ter_column_with_interger_array_and_options.msql | 0 ...lter_column_with_interger_array_and_options.sql | 0 .../tests/pg/default/create_column_char.msql | 4 +- .../tests/pg/default/create_column_char.sql | 8 +- .../create_column_identity_for_restart_seq.msql | 0 .../create_column_identity_for_restart_seq.sql | 0 .../tests/pg/default/create_column_int.msql | 4 +- .../columns/tests/pg/default/create_column_int.sql | 8 +- .../create_column_int_identity.msql | 0 .../create_column_int_identity.sql | 0 .../create_column_int_identity_by_default.msql | 0 .../create_column_int_identity_by_default.sql | 0 .../tests/pg/default/create_column_numeric.msql | 10 +- .../tests/pg/default/create_column_numeric.sql | 14 +- .../create_column_text_with_default_value.msql | 0 .../create_column_text_with_default_value.sql | 0 ...imestamp_with_default_value_using_function.msql | 0 ...timestamp_with_default_value_using_function.sql | 0 ...ate_column_with_interger_array_and_options.msql | 0 ...eate_column_with_interger_array_and_options.sql | 0 .../tables/columns/tests/pg/default/test.json | 413 +++- .../ppas/10_plus/alter_column_alt_privilege.msql | 2 - .../ppas/10_plus/alter_column_alt_privilege.sql | 13 - .../tests/ppas/10_plus/alter_column_char.msql | 15 - .../tests/ppas/10_plus/alter_column_char.sql | 17 - .../tests/ppas/10_plus/alter_column_int.msql | 9 - .../tests/ppas/10_plus/alter_column_int.sql | 11 - .../tests/ppas/10_plus/alter_column_numeric.msql | 9 - .../tests/ppas/10_plus/alter_column_numeric.sql | 15 - .../ppas/10_plus/alter_column_remove_length.msql | 2 - .../ppas/10_plus/alter_column_remove_length.sql | 15 - .../tests/ppas/10_plus/create_column_char.msql | 5 - .../tests/ppas/10_plus/create_column_char.sql | 9 - .../tests/ppas/10_plus/create_column_int.msql | 5 - .../tests/ppas/10_plus/create_column_int.sql | 9 - .../tests/ppas/10_plus/create_column_numeric.msql | 9 - .../tests/ppas/10_plus/create_column_numeric.sql | 13 - .../tables/columns/tests/ppas/10_plus/test.json | 530 ------ .../ppas/default/alter_column_alt_privilege.msql | 4 +- .../ppas/default/alter_column_alt_privilege.sql | 12 +- .../tests/ppas/default/alter_column_char.msql | 12 +- .../tests/ppas/default/alter_column_char.sql | 14 +- .../alter_column_drop_identity.msql | 0 .../alter_column_drop_identity.sql | 0 .../alter_column_drop_identity_by_default.msql | 0 .../alter_column_drop_identity_by_default.sql | 0 .../alter_column_identity.msql | 0 .../{10_plus => default}/alter_column_identity.sql | 0 .../alter_column_identity_by_default.msql | 0 .../alter_column_identity_by_default.sql | 0 .../alter_column_identity_for_comb_start_seq.msql | 0 .../alter_column_identity_for_comb_start_seq.sql | 0 .../alter_column_identity_for_restart_seq.msql | 0 .../alter_column_identity_for_restart_seq.sql | 0 .../tests/ppas/default/alter_column_int.msql | 8 +- .../tests/ppas/default/alter_column_int.sql | 10 +- .../tests/ppas/default/alter_column_numeric.msql | 12 +- .../tests/ppas/default/alter_column_numeric.sql | 16 +- .../ppas/default/alter_column_remove_length.msql | 4 +- .../ppas/default/alter_column_remove_length.sql | 16 +- .../alter_column_text_with_default_value.msql | 0 .../alter_column_text_with_default_value.sql | 0 .../tests/ppas/default/create_column_char.msql | 4 +- .../tests/ppas/default/create_column_char.sql | 8 +- .../create_column_identity_for_restart_seq.msql | 0 .../create_column_identity_for_restart_seq.sql | 0 .../tests/ppas/default/create_column_int.msql | 4 +- .../tests/ppas/default/create_column_int.sql | 8 +- .../create_column_int_identity.msql | 0 .../create_column_int_identity.sql | 0 .../create_column_int_identity_by_default.msql | 0 .../create_column_int_identity_by_default.sql | 0 .../tests/ppas/default/create_column_numeric.msql | 10 +- .../tests/ppas/default/create_column_numeric.sql | 14 +- .../tables/columns/tests/ppas/default/test.json | 247 ++- .../alter_name_comment_validation.sql | 0 .../alter_name_comment_validation_msql.sql | 0 .../create_foreign_key_cascade.sql | 0 .../create_foreign_key_cascade_msql.sql | 0 .../create_foreign_key_restrict.sql | 0 .../create_foreign_key_restrict_msql.sql | 0 .../create_foreign_key_setdefault.sql | 0 .../create_foreign_key_setdefault_msql.sql | 0 .../create_foreign_key_setnull.sql | 0 .../create_foreign_key_setnull_msql.sql | 0 .../create_foreign_key_simple.sql | 0 .../create_foreign_key_simple_msql.sql | 0 .../create_foreign_key_with_all_options.sql | 0 .../create_foreign_key_with_all_options_msql.sql | 0 .../{9.3_plus => default}/test_foreign_keys.json | 0 .../10_plus/alter_delete_policy_with_using.sql | 10 - .../alter_delete_policy_with_using_msql.sql | 2 - .../tests/10_plus/alter_select_policy.sql | 10 - .../tests/10_plus/alter_select_policy_msql.sql | 2 - .../tests/10_plus/alter_simple_all_policy.sql | 11 - .../tests/10_plus/alter_simple_all_policy_msql.sql | 5 - .../tests/10_plus/alter_simple_insert_policy.sql | 10 - .../10_plus/alter_simple_insert_policy_msql.sql | 2 - .../alter_update_policy_with_check_and_using.sql | 11 - ...ter_update_policy_with_check_and_using_msql.sql | 5 - .../10_plus/create_delete_policy_with_using.sql | 10 - .../create_delete_policy_with_using_msql.sql | 6 - .../tests/10_plus/create_select_policy.sql | 9 - .../tests/10_plus/create_select_policy_msql.sql | 5 - .../tests/10_plus/create_simple_all_policy.sql | 9 - .../10_plus/create_simple_all_policy_msql.sql | 5 - .../tests/10_plus/create_simple_insert_policy.sql | 9 - .../10_plus/create_simple_insert_policy_msql.sql | 5 - .../create_update_policy_with_check_and_using.sql | 11 - ...ate_update_policy_with_check_and_using_msql.sql | 7 - .../row_security_policies/tests/10_plus/test.json | 275 --- .../default/alter_delete_policy_with_using.sql | 1 + .../default/alter_insert_policy_with_check.sql | 9 - .../alter_insert_policy_with_check_msql.sql | 5 - .../tests/{10_plus => default}/alter_policy.sql | 0 .../{10_plus => default}/alter_policy_msql.sql | 0 .../tests/default/alter_select_policy.sql | 3 +- .../tests/default/alter_simple_all_policy.sql | 1 + .../tests/default/alter_simple_insert_policy.sql | 3 +- .../alter_update_policy_with_check_and_using.sql | 3 +- .../create_all_event_policy.sql | 0 .../default/create_delete_policy_with_using.sql | 3 +- .../create_delete_policy_with_using_msql.sql | 1 + .../default/create_insert_policy_with_check.sql | 9 - .../create_insert_policy_with_check_msql.sql | 5 - .../{10_plus => default}/create_public_policy.sql | 0 .../tests/default/create_select_policy.sql | 1 + .../tests/default/create_select_policy_msql.sql | 1 + .../tests/default/create_simple_all_policy.sql | 1 + .../default/create_simple_all_policy_msql.sql | 1 + .../tests/default/create_simple_insert_policy.sql | 1 + .../default/create_simple_insert_policy_msql.sql | 1 + .../create_update_policy_with_check_and_using.sql | 1 + ...ate_update_policy_with_check_and_using_msql.sql | 1 + .../row_security_policies/tests/default/test.json | 68 +- .../check_constraint/sql/9.2_plus/create.sql | 11 - .../check_constraint/sql/9.2_plus/get_name.sql | 5 - .../check_constraint/sql/9.2_plus/get_oid.sql | 8 - .../sql/9.2_plus/get_oid_with_transaction.sql | 6 - .../check_constraint/sql/9.2_plus/nodes.sql | 8 - .../check_constraint/sql/9.2_plus/properties.sql | 14 - .../check_constraint/sql/9.2_plus/update.sql | 13 - .../check_constraint/sql/default/create.sql | 8 +- .../check_constraint/sql/default/get_name.sql | 3 +- .../check_constraint/sql/default/get_oid.sql | 3 +- .../sql/default/get_oid_with_transaction.sql | 3 +- .../check_constraint/sql/default/nodes.sql | 3 +- .../check_constraint/sql/default/properties.sql | 5 +- .../check_constraint/sql/default/update.sql | 15 +- .../sql/{9.2_plus => default}/validate.sql | 0 .../templates/columns/sql/10_plus/create.sql | 60 - .../templates/columns/sql/10_plus/properties.sql | 41 - .../templates/columns/sql/10_plus/update.sql | 209 -- .../tables/templates/columns/sql/9.1_plus/acl.sql | 39 - .../templates/columns/sql/9.1_plus/properties.sql | 46 - .../columns/sql/9.2_plus/get_collations.sql | 7 - .../templates/columns/sql/9.2_plus/nodes.sql | 27 - .../templates/columns/sql/9.2_plus/properties.sql | 37 - .../templates/columns/sql/9.2_plus/update.sql | 169 -- .../tables/templates/columns/sql/default/acl.sql | 40 +- .../templates/columns/sql/default/create.sql | 13 +- .../templates/columns/sql/default/properties.sql | 40 +- .../templates/columns/sql/default/update.sql | 54 +- .../sql/9.1_plus/get_oid_with_transaction.sql | 6 - .../exclusion_constraint/sql/9.1_plus/nodes.sql | 10 - .../sql/9.2_plus/get_constraint_cols.sql | 23 - .../sql/9.2_plus/get_operator.sql | 36 - .../sql/9.6_plus/get_access_methods.sql | 6 - .../sql/default/get_access_methods.sql | 2 +- .../sql/default/get_constraint_cols.sql | 3 +- .../sql/default/get_oid_with_transaction.sql | 2 +- .../sql/default/get_operator.sql | 1 + .../exclusion_constraint/sql/default/nodes.sql | 11 +- .../templates/foreign_key/sql/9.1_plus/__init__.py | 0 .../templates/foreign_key/sql/9.1_plus/get_oid.sql | 5 - .../sql/9.1_plus/get_oid_with_transaction.sql | 6 - .../templates/foreign_key/sql/9.1_plus/nodes.sql | 7 - .../foreign_key/sql/9.1_plus/properties.sql | 32 - .../templates/foreign_key/sql/default/get_oid.sql | 2 +- .../sql/default/get_oid_with_transaction.sql | 2 +- .../templates/foreign_key/sql/default/nodes.sql | 2 +- .../foreign_key/sql/default/properties.sql | 5 +- .../sql/pg/{10_plus => default}/attach.sql | 0 .../pg/{10_plus => default}/backend_support.sql | 0 .../sql/pg/{10_plus => default}/create.sql | 0 .../sql/pg/{10_plus => default}/detach.sql | 0 .../pg/{10_plus => default}/get_attach_tables.sql | 0 .../sql/pg/{10_plus => default}/nodes.sql | 0 .../sql/pg/{10_plus => default}/partition_diff.sql | 0 .../sql/pg/{10_plus => default}/properties.sql | 0 .../sql/ppas/{10_plus => default}/attach.sql | 0 .../ppas/{10_plus => default}/backend_support.sql | 0 .../sql/ppas/{10_plus => default}/create.sql | 0 .../sql/ppas/{10_plus => default}/detach.sql | 0 .../{10_plus => default}/get_attach_tables.sql | 0 .../sql/ppas/{10_plus => default}/nodes.sql | 0 .../ppas/{10_plus => default}/partition_diff.sql | 0 .../sql/ppas/{10_plus => default}/properties.sql | 0 .../row_security_policies/sql/10_plus/create.sql | 27 - .../sql/10_plus/properties.sql | 23 - .../row_security_policies/sql/9.5_plus/create.sql | 24 - .../row_security_policies/sql/9.5_plus/delete.sql | 1 - .../sql/9.5_plus/get_parent.sql | 5 - .../sql/9.5_plus/get_policy_name.sql | 9 - .../sql/9.5_plus/get_position.sql | 2 - .../row_security_policies/sql/9.5_plus/nodes.sql | 17 - .../sql/9.5_plus/properties.sql | 22 - .../row_security_policies/sql/9.5_plus/update.sql | 33 - .../row_security_policies/sql/default/create.sql | 3 + .../sql/default/properties.sql | 1 + .../tables/templates/tables/sql/10_plus/acl.sql | 46 - .../tables/templates/tables/sql/10_plus/create.sql | 208 -- .../tables/sql/10_plus/get_columns_for_table.sql | 19 - .../templates/tables/sql/10_plus/get_inherits.sql | 17 - .../templates/tables/sql/10_plus/get_oid.sql | 5 - .../templates/tables/sql/10_plus/get_table.sql | 8 - .../tables/templates/tables/sql/10_plus/nodes.sql | 15 - .../templates/tables/sql/10_plus/properties.sql | 74 - .../tables/templates/tables/sql/10_plus/update.sql | 269 --- .../tables/templates/tables/sql/9.1_plus/acl.sql | 46 - .../templates/tables/sql/9.1_plus/get_inherits.sql | 17 - .../tables/templates/tables/sql/9.1_plus/nodes.sql | 13 - .../templates/tables/sql/9.1_plus/properties.sql | 63 - .../tables/templates/tables/sql/9.1_plus/stats.sql | 57 - .../tables/templates/tables/sql/9.2_plus/stats.sql | 57 - .../templates/tables/sql/9.6_plus/create.sql | 197 -- .../templates/tables/sql/9.6_plus/properties.sql | 64 - .../templates/tables/sql/9.6_plus/update.sql | 274 --- .../tables/templates/tables/sql/default/acl.sql | 79 +- .../tables/templates/tables/sql/default/create.sql | 56 +- .../tables/sql/default/get_columns_for_table.sql | 2 +- .../templates/tables/sql/default/get_inherits.sql | 3 +- .../templates/tables/sql/default/get_oid.sql | 2 +- .../templates/tables/sql/default/get_table.sql | 2 +- .../tables/templates/tables/sql/default/nodes.sql | 12 +- .../templates/tables/sql/default/properties.sql | 141 +- .../tables/templates/tables/sql/default/update.sql | 23 +- .../templates/triggers/sql/pg/10_plus/create.sql | 37 - .../triggers/sql/pg/10_plus/properties.sql | 24 - .../templates/triggers/sql/pg/9.1_plus/get_oid.sql | 5 - .../templates/triggers/sql/pg/9.1_plus/nodes.sql | 12 - .../triggers/sql/pg/9.1_plus/properties.sql | 22 - .../templates/triggers/sql/pg/default/create.sql | 4 + .../pg/{9.1_plus => default}/get_function_oid.sql | 0 .../templates/triggers/sql/pg/default/get_oid.sql | 3 +- .../templates/triggers/sql/pg/default/nodes.sql | 7 +- .../triggers/sql/pg/default/properties.sql | 25 +- .../templates/triggers/sql/ppas/10_plus/create.sql | 37 - .../triggers/sql/ppas/10_plus/properties.sql | 24 - .../triggers/sql/ppas/9.1_plus/get_oid.sql | 5 - .../templates/triggers/sql/ppas/9.1_plus/nodes.sql | 12 - .../triggers/sql/ppas/9.1_plus/properties.sql | 22 - .../templates/triggers/sql/ppas/default/create.sql | 4 + .../{9.1_plus => default}/get_function_oid.sql | 0 .../triggers/sql/ppas/default/get_oid.sql | 3 +- .../templates/triggers/sql/ppas/default/nodes.sql | 7 +- .../triggers/sql/ppas/default/properties.sql | 25 +- .../pg/10_plus/alter_table_with_toast_table.sql | 33 - .../10_plus/alter_table_with_toast_table_msql.sql | 15 - .../schemas/tables/tests/pg/10_plus/test.json | 1947 ------------------- .../schemas/tables/tests/pg/11_plus/test.json | 1437 -------------- .../schemas/tables/tests/pg/12_plus/test.json | 1437 -------------- .../default/alter_table_with_toast_table_msql.sql | 1 + .../create_partition_table_with_collate.sql | 0 .../create_partition_table_with_collate_msql.sql | 0 .../create_table_with_partition.sql | 0 .../create_table_with_partition_msql.sql | 0 .../create_table_with_range_partition.sql | 0 .../create_table_with_range_partition_msql.sql | 0 .../schemas/tables/tests/pg/default/test.json | 450 +++++ .../ppas/10_plus/alter_table_with_toast_table.sql | 33 - .../10_plus/alter_table_with_toast_table_msql.sql | 15 - .../schemas/tables/tests/ppas/10_plus/test.json | 1947 ------------------- .../schemas/tables/tests/ppas/11_plus/test.json | 2008 +------------------- .../default/alter_table_with_toast_table_msql.sql | 1 + .../create_partition_table_with_collate.sql | 0 .../create_partition_table_with_collate_msql.sql | 0 .../create_table_with_partition.sql | 0 .../create_table_with_partition_msql.sql | 0 .../create_table_with_range_partition.sql | 0 .../create_table_with_range_partition_msql.sql | 0 .../schemas/tables/tests/ppas/default/test.json | 450 +++++ .../pg/default}/allowed_privs.json | 4 +- .../9.1_plus => catalog/pg/default}/sql/acl.sql | 3 +- .../templates/catalog/pg/default/sql/create.sql | 17 + .../pg/default}/sql/get_name.sql | 0 .../pg/default}/sql/is_catalog.sql | 0 .../9.2_plus => catalog/pg/default}/sql/nodes.sql | 16 +- .../catalog/pg/default/sql/properties.sql | 25 + .../templates/catalog/pg/default/sql/update.sql | 30 + .../catalog/ppas/default}/allowed_privs.json | 6 +- .../9.2_plus => catalog/ppas/default}/sql/acl.sql | 3 +- .../templates/catalog/ppas/default/sql/create.sql | 17 + .../ppas/default}/sql/get_name.sql | 0 .../ppas/default}/sql/is_catalog.sql | 0 .../ppas/default}/sql/nodes.sql | 16 +- .../catalog/ppas/default/sql/properties.sql | 27 + .../templates/catalog/ppas/default/sql/update.sql | 30 + .../templates/schemas/pg/9.2_plus/sql/defacl.sql | 40 - .../schemas/pg/9.2_plus/sql/properties.sql | 57 - .../templates/schemas/pg/9.2_plus/sql/update.sql | 91 - .../schemas/pg/default/allowed_privs.json | 6 +- .../templates/schemas/pg/default/sql/create.sql | 2 +- .../templates/schemas/pg/default/sql/defacl.sql | 3 +- .../templates/schemas/pg/default/sql/nodes.sql | 6 + .../schemas/pg/default/sql/properties.sql | 10 + .../templates/schemas/pg/default/sql/update.sql | 2 +- .../schemas/ppas/9.1_plus/allowed_privs.json | 26 - .../templates/schemas/ppas/9.1_plus/sql/create.sql | 40 - .../templates/schemas/ppas/9.1_plus/sql/defacl.sql | 39 - .../templates/schemas/ppas/9.1_plus/sql/delete.sql | 1 - .../templates/schemas/ppas/9.1_plus/sql/oid.sql | 1 - .../schemas/ppas/9.1_plus/sql/properties.sql | 51 - .../templates/schemas/ppas/9.1_plus/sql/update.sql | 133 -- .../templates/schemas/ppas/9.2_plus/sql/create.sql | 40 - .../templates/schemas/ppas/9.2_plus/sql/delete.sql | 1 - .../templates/schemas/ppas/9.2_plus/sql/oid.sql | 1 - .../ppas/{9.2_plus => default}/allowed_privs.json | 0 .../{pg/9.2_plus => ppas/default}/sql/acl.sql | 0 .../{pg/9.2_plus => ppas/default}/sql/create.sql | 0 .../ppas/{9.2_plus => default}/sql/defacl.sql | 0 .../{pg/9.2_plus => ppas/default}/sql/delete.sql | 0 .../ppas/{9.2_plus => default}/sql/get_name.sql | 0 .../ppas/{9.2_plus => default}/sql/is_catalog.sql | 0 .../ppas/{9.1_plus => default}/sql/nodes.sql | 0 .../{pg/9.2_plus => ppas/default}/sql/oid.sql | 0 .../ppas/{9.2_plus => default}/sql/properties.sql | 0 .../ppas/{9.2_plus => default}/sql/update.sql | 0 .../alter_schema_add_priv.sql | 0 .../alter_schema_add_priv_msql.sql | 0 .../alter_schema_drop_priv.sql | 0 .../alter_schema_drop_priv_msql.sql | 0 .../pg/{9.2_plus => default}/alter_schema_name.sql | 0 .../alter_schema_name_msql.sql | 0 .../alter_schema_update_priv.sql | 0 .../alter_schema_update_priv_msql.sql | 0 .../create_schema_all_options.sql | 0 .../create_schema_all_options_msql.sql | 0 .../create_schema_with_comment.sql | 0 .../create_schema_with_comment_msql.sql | 0 .../pg/{9.2_plus => default}/test_schema.json | 0 .../alter_schema_add_priv.sql | 0 .../alter_schema_add_priv_msql.sql | 0 .../alter_schema_drop_priv.sql | 0 .../alter_schema_drop_priv_msql.sql | 0 .../{9.2_plus => default}/alter_schema_name.sql | 0 .../alter_schema_name_msql.sql | 0 .../alter_schema_update_priv.sql | 0 .../alter_schema_update_priv_msql.sql | 0 .../create_schema_all_options.sql | 0 .../create_schema_all_options_msql.sql | 0 .../create_schema_with_comment.sql | 0 .../create_schema_with_comment_msql.sql | 0 .../ppas/{9.2_plus => default}/test_schema.json | 0 .../servers/databases/schemas/views/__init__.py | 9 +- .../templates/mviews/pg/9.3_plus/sql/refresh.sql | 2 - .../views/templates/mviews/pg/9.4_plus/sql/acl.sql | 41 - .../mviews/pg/9.4_plus/sql/properties.sql | 109 -- .../mviews/pg/{9.3_plus => default}/sql/acl.sql | 0 .../{9.3_plus => default}/sql/allowed_privs.json | 0 .../mviews/pg/{9.4_plus => default}/sql/create.sql | 0 .../mviews/pg/{9.3_plus => default}/sql/delete.sql | 0 .../pg/{9.3_plus => default}/sql/get_oid.sql | 0 .../pg/{9.3_plus => default}/sql/get_schema.sql | 0 .../pg/{9.3_plus => default}/sql/get_view_name.sql | 0 .../mviews/pg/{9.3_plus => default}/sql/grant.sql | 0 .../mviews/pg/{9.3_plus => default}/sql/nodes.sql | 0 .../pg/{9.3_plus => default}/sql/properties.sql | 0 .../pg/{9.4_plus => default}/sql/refresh.sql | 0 .../mviews/pg/{9.3_plus => default}/sql/update.sql | 0 .../pg/{9.3_plus => default}/sql/view_id.sql | 0 .../mviews/ppas/9.3_plus/sql/allowed_privs.json | 6 - .../templates/mviews/ppas/9.3_plus/sql/create.sql | 45 - .../templates/mviews/ppas/9.3_plus/sql/delete.sql | 13 - .../mviews/ppas/9.3_plus/sql/get_schema.sql | 7 - .../mviews/ppas/9.3_plus/sql/get_view_name.sql | 11 - .../templates/mviews/ppas/9.3_plus/sql/grant.sql | 6 - .../templates/mviews/ppas/9.3_plus/sql/nodes.sql | 17 - .../templates/mviews/ppas/9.3_plus/sql/update.sql | 199 -- .../templates/mviews/ppas/9.3_plus/sql/view_id.sql | 6 - .../mviews/ppas/{9.3_plus => default}/sql/acl.sql | 0 .../default}/sql/allowed_privs.json | 0 .../{pg/9.3_plus => ppas/default}/sql/create.sql | 0 .../{pg/9.4_plus => ppas/default}/sql/delete.sql | 0 .../{pg/9.4_plus => ppas/default}/sql/get_oid.sql | 0 .../9.4_plus => ppas/default}/sql/get_schema.sql | 0 .../default}/sql/get_view_name.sql | 0 .../{pg/9.4_plus => ppas/default}/sql/grant.sql | 0 .../{pg/9.4_plus => ppas/default}/sql/nodes.sql | 0 .../ppas/{9.3_plus => default}/sql/properties.sql | 0 .../ppas/{9.3_plus => default}/sql/refresh.sql | 0 .../{pg/9.4_plus => ppas/default}/sql/update.sql | 0 .../{pg/9.4_plus => ppas/default}/sql/view_id.sql | 0 .../views/templates/views/pg/9.1_plus/sql/acl.sql | 51 - .../templates/views/pg/9.1_plus/sql/create.sql | 20 - .../templates/views/pg/9.1_plus/sql/delete.sql | 13 - .../templates/views/pg/9.1_plus/sql/properties.sql | 63 - .../templates/views/pg/9.1_plus/sql/update.sql | 71 - .../views/templates/views/pg/9.2_plus/sql/acl.sql | 52 - .../templates/views/pg/9.2_plus/sql/create.sql | 24 - .../templates/views/pg/9.2_plus/sql/delete.sql | 13 - .../templates/views/pg/9.2_plus/sql/get_oid.sql | 9 - .../templates/views/pg/9.2_plus/sql/properties.sql | 66 - .../templates/views/pg/9.2_plus/sql/update.sql | 79 - .../templates/views/pg/9.2_plus/sql/view_id.sql | 6 - .../views/templates/views/pg/9.3_plus/sql/acl.sql | 38 - .../views/pg/9.3_plus/sql/allowed_privs.json | 6 - .../templates/views/pg/9.3_plus/sql/create.sql | 23 - .../templates/views/pg/9.3_plus/sql/get_oid.sql | 9 - .../templates/views/pg/9.3_plus/sql/get_schema.sql | 7 - .../templates/views/pg/9.3_plus/sql/grant.sql | 6 - .../templates/views/pg/9.3_plus/sql/nodes.sql | 17 - .../templates/views/pg/9.3_plus/sql/properties.sql | 68 - .../templates/views/pg/9.3_plus/sql/update.sql | 79 - .../templates/views/pg/9.3_plus/sql/view_id.sql | 6 - .../views/pg/9.4_plus/sql/allowed_privs.json | 6 - .../templates/views/pg/9.4_plus/sql/get_oid.sql | 9 - .../templates/views/pg/9.4_plus/sql/get_schema.sql | 7 - .../templates/views/pg/9.4_plus/sql/grant.sql | 6 - .../templates/views/pg/9.4_plus/sql/nodes.sql | 17 - .../templates/views/pg/9.4_plus/sql/view_id.sql | 6 - .../views/pg/{9.4_plus => default}/sql/acl.sql | 0 .../{9.1_plus => default}/sql/allowed_privs.json | 0 .../views/pg/{9.4_plus => default}/sql/create.sql | 0 .../views/pg/{9.4_plus => default}/sql/delete.sql | 0 .../9.3_plus => views/pg/default}/sql/get_oid.sql | 0 .../pg/{9.1_plus => default}/sql/get_schema.sql | 0 .../views/pg/{9.1_plus => default}/sql/grant.sql | 0 .../views/pg/{9.1_plus => default}/sql/nodes.sql | 0 .../pg/{9.4_plus => default}/sql/properties.sql | 0 .../views/pg/{9.4_plus => default}/sql/update.sql | 0 .../views/pg/{9.1_plus => default}/sql/view_id.sql | 0 .../templates/views/ppas/9.1_plus/sql/acl.sql | 39 - .../views/ppas/9.1_plus/sql/allowed_privs.json | 6 - .../templates/views/ppas/9.1_plus/sql/create.sql | 20 - .../templates/views/ppas/9.1_plus/sql/delete.sql | 13 - .../templates/views/ppas/9.1_plus/sql/get_oid.sql | 9 - .../views/ppas/9.1_plus/sql/get_schema.sql | 7 - .../templates/views/ppas/9.1_plus/sql/grant.sql | 6 - .../templates/views/ppas/9.1_plus/sql/nodes.sql | 17 - .../views/ppas/9.1_plus/sql/properties.sql | 70 - .../templates/views/ppas/9.1_plus/sql/update.sql | 79 - .../templates/views/ppas/9.1_plus/sql/view_id.sql | 6 - .../templates/views/ppas/9.2_plus/sql/acl.sql | 52 - .../views/ppas/9.2_plus/sql/allowed_privs.json | 6 - .../templates/views/ppas/9.2_plus/sql/create.sql | 23 - .../templates/views/ppas/9.2_plus/sql/delete.sql | 13 - .../templates/views/ppas/9.2_plus/sql/get_oid.sql | 9 - .../views/ppas/9.2_plus/sql/get_schema.sql | 7 - .../templates/views/ppas/9.2_plus/sql/grant.sql | 6 - .../templates/views/ppas/9.2_plus/sql/nodes.sql | 17 - .../views/ppas/9.2_plus/sql/properties.sql | 65 - .../templates/views/ppas/9.2_plus/sql/update.sql | 79 - .../templates/views/ppas/9.2_plus/sql/view_id.sql | 6 - .../templates/views/ppas/9.3_plus/sql/acl.sql | 38 - .../views/ppas/9.3_plus/sql/allowed_privs.json | 6 - .../templates/views/ppas/9.3_plus/sql/create.sql | 23 - .../templates/views/ppas/9.3_plus/sql/delete.sql | 13 - .../templates/views/ppas/9.3_plus/sql/get_oid.sql | 9 - .../views/ppas/9.3_plus/sql/get_schema.sql | 7 - .../templates/views/ppas/9.3_plus/sql/grant.sql | 6 - .../templates/views/ppas/9.3_plus/sql/nodes.sql | 17 - .../views/ppas/9.3_plus/sql/properties.sql | 68 - .../templates/views/ppas/9.3_plus/sql/update.sql | 79 - .../templates/views/ppas/9.3_plus/sql/view_id.sql | 6 - .../views/ppas/9.4_plus/sql/allowed_privs.json | 6 - .../templates/views/ppas/9.4_plus/sql/delete.sql | 13 - .../templates/views/ppas/9.4_plus/sql/get_oid.sql | 9 - .../views/ppas/9.4_plus/sql/get_schema.sql | 7 - .../templates/views/ppas/9.4_plus/sql/grant.sql | 6 - .../templates/views/ppas/9.4_plus/sql/nodes.sql | 17 - .../views/ppas/{9.4_plus => default}/sql/acl.sql | 0 .../default}/sql/allowed_privs.json | 0 .../ppas/{9.4_plus => default}/sql/create.sql | 0 .../{pg/9.3_plus => ppas/default}/sql/delete.sql | 0 .../{pg/9.1_plus => ppas/default}/sql/get_oid.sql | 0 .../9.2_plus => ppas/default}/sql/get_schema.sql | 0 .../{pg/9.2_plus => ppas/default}/sql/grant.sql | 0 .../{pg/9.2_plus => ppas/default}/sql/nodes.sql | 0 .../ppas/{9.4_plus => default}/sql/properties.sql | 0 .../ppas/{9.4_plus => default}/sql/update.sql | 0 .../ppas/{9.4_plus => default}/sql/view_id.sql | 0 .../tests/pg/{9.4_plus => default}/alter_mview.sql | 0 .../alter_mview_add_fillfactor.sql | 0 .../alter_mview_add_fillfactor_msql.sql | 0 .../alter_mview_add_table_parameter.sql | 0 .../alter_mview_add_table_parameter_msql.sql | 0 .../alter_mview_change_grantee_priv.sql | 0 .../alter_mview_change_grantee_priv_msql.sql | 0 .../alter_mview_definition.sql | 0 .../alter_mview_definition_msql.sql | 0 .../alter_mview_drop_all_priv.sql | 0 .../alter_mview_drop_all_priv_msql.sql | 0 .../pg/{9.4_plus => default}/alter_mview_msql.sql | 0 .../alter_mview_remove_table_parameter.sql | 0 .../alter_mview_remove_table_parameter_msql.sql | 0 .../tests/pg/{9.4_plus => default}/alter_view.sql | 0 .../alter_view_add_some_priv.sql | 0 .../alter_view_add_some_priv_msql.sql | 0 .../alter_view_definition.sql | 0 .../alter_view_definition_msql.sql | 0 .../alter_view_delete_priv.sql | 0 .../alter_view_delete_priv_msql.sql | 0 .../pg/{9.4_plus => default}/alter_view_msql.sql | 0 .../alter_view_update_priv.sql | 0 .../alter_view_update_priv_msql.sql | 0 .../pg/{9.4_plus => default}/create_mview.sql | 0 .../pg/{9.4_plus => default}/create_mview_msql.sql | 0 .../tests/pg/{9.4_plus => default}/create_view.sql | 0 .../pg/{9.4_plus => default}/create_view_msql.sql | 0 .../tests/pg/{9.4_plus => default}/test_mview.json | 0 .../tests/pg/{9.4_plus => default}/tests.json | 0 .../ppas/{9.4_plus => default}/alter_mview.sql | 0 .../alter_mview_add_fillfactor.sql | 0 .../alter_mview_add_fillfactor_msql.sql | 0 .../alter_mview_add_table_parameter.sql | 0 .../alter_mview_add_table_parameter_msql.sql | 0 .../alter_mview_change_grantee_priv.sql | 0 .../alter_mview_change_grantee_priv_msql.sql | 0 .../alter_mview_definition.sql | 0 .../alter_mview_definition_msql.sql | 0 .../alter_mview_drop_all_priv.sql | 0 .../alter_mview_drop_all_priv_msql.sql | 0 .../{9.4_plus => default}/alter_mview_msql.sql | 0 .../alter_mview_remove_table_parameter.sql | 0 .../alter_mview_remove_table_parameter_msql.sql | 0 .../ppas/{9.4_plus => default}/alter_view.sql | 0 .../alter_view_add_some_priv.sql | 0 .../alter_view_add_some_priv_msql.sql | 0 .../alter_view_definition.sql | 0 .../alter_view_definition_msql.sql | 0 .../alter_view_delete_priv.sql | 0 .../alter_view_delete_priv_msql.sql | 0 .../ppas/{9.4_plus => default}/alter_view_msql.sql | 0 .../alter_view_update_priv.sql | 0 .../alter_view_update_priv_msql.sql | 0 .../ppas/{9.4_plus => default}/create_mview.sql | 0 .../{9.4_plus => default}/create_mview_msql.sql | 0 .../ppas/{9.4_plus => default}/create_view.sql | 0 .../{9.4_plus => default}/create_view_msql.sql | 0 .../ppas/{9.4_plus => default}/test_mview.json | 0 .../tests/ppas/{9.4_plus => default}/tests.json | 0 .../{10_plus => default}/alter_maintenance_db.sql | 0 .../{10_plus => default}/alter_subscription.sql | 0 .../tests/{10_plus => default}/alter_sync.sql | 0 .../{10_plus => default}/create_subscription.sql | 0 .../create_subscription_msql.sql | 0 .../tests/{10_plus => default}/test.json | 0 .../databases/sql/10_plus/alter_online.sql | 147 -- .../templates/databases/sql/10_plus/create.sql | 21 - .../templates/databases/sql/10_plus/properties.sql | 42 - .../templates/databases/sql/9.1_plus/acl.sql | 35 - .../templates/databases/sql/9.1_plus/defacl.sql | 34 - .../databases/sql/9.1_plus/get_ctypes.sql | 5 - .../databases/sql/9.1_plus/get_variables.sql | 5 - .../databases/sql/9.1_plus/properties.sql | 45 - .../templates/databases/sql/9.2_plus/acl.sql | 35 - .../databases/sql/9.2_plus/alter_online.sql | 157 -- .../templates/databases/sql/9.2_plus/delete.sql | 8 - .../databases/sql/9.2_plus/get_encodings.sql | 18 - .../databases/sql/9.2_plus/get_variables.sql | 7 - .../templates/databases/sql/9.2_plus/grant.sql | 58 - .../databases/sql/9.2_plus/properties.sql | 55 - .../templates/databases/sql/9.2_plus/stats.sql | 38 - .../templates/databases/sql/9.2_plus/variables.sql | 4 - .../templates/databases/sql/9.3_plus/acl.sql | 35 - .../databases/sql/9.3_plus/alter_offline.sql | 22 - .../databases/sql/9.3_plus/alter_online.sql | 157 -- .../templates/databases/sql/9.3_plus/defacl.sql | 161 -- .../databases/sql/9.3_plus/get_variables.sql | 6 - .../templates/databases/sql/9.3_plus/grant.sql | 83 - .../templates/databases/sql/9.6_plus/delete.sql | 8 - .../templates/databases/sql/default/acl.sql | 38 +- .../databases/sql/default/alter_online.sql | 57 +- .../templates/databases/sql/default/create.sql | 4 +- .../templates/databases/sql/default/defacl.sql | 166 +- .../templates/databases/sql/default/delete.sql | 2 +- .../databases/sql/default/get_variables.sql | 8 +- .../templates/databases/sql/default/grant.sql | 47 +- .../templates/databases/sql/default/properties.sql | 22 +- .../roles/templates/roles/sql/9.1_plus/create.sql | 61 - .../templates/roles/sql/9.1_plus/dependents.sql | 40 - .../templates/roles/sql/9.1_plus/permission.sql | 5 - .../templates/roles/sql/9.1_plus/properties.sql | 26 - .../roles/templates/roles/sql/9.1_plus/sql.sql | 118 -- .../roles/templates/roles/sql/9.1_plus/update.sql | 138 -- .../roles/templates/roles/sql/9.4_plus/nodes.sql | 8 - .../templates/roles/sql/9.4_plus/variables.sql | 25 - .../roles/sql/{9.4_plus => default}/create.sql | 0 .../roles/sql/{9.4_plus => default}/dependents.sql | 0 .../roles/sql/{9.1_plus => default}/nodes.sql | 0 .../roles/sql/{9.4_plus => default}/permission.sql | 0 .../roles/sql/{9.4_plus => default}/properties.sql | 0 .../sql/{9.4_plus => default}/reassign_own.sql | 0 .../roles/sql/{9.4_plus => default}/sql.sql | 0 .../roles/sql/{9.4_plus => default}/update.sql | 0 .../roles/sql/{9.1_plus => default}/variables.sql | 0 .../9.1_plus/alter_login_role_description.msql | 1 - .../9.1_plus/alter_login_role_description.sql | 15 - .../tests/9.1_plus/alter_login_role_name.msql | 2 - .../roles/tests/9.1_plus/alter_login_role_name.sql | 15 - .../tests/9.1_plus/alter_login_role_options.msql | 11 - .../tests/9.1_plus/alter_login_role_options.sql | 16 - .../tests/9.1_plus/alter_role_description.msql | 1 - .../roles/tests/9.1_plus/alter_role_name.msql | 2 - .../roles/tests/9.1_plus/alter_role_options.msql | 11 - .../roles/tests/9.1_plus/alter_role_options.sql | 16 - .../roles/tests/9.1_plus/create_login_role.msql | 9 - .../roles/tests/9.1_plus/create_login_role.sql | 13 - .../servers/roles/tests/9.1_plus/create_role.msql | 9 - .../servers/roles/tests/9.1_plus/test.json | 148 -- .../tests/9.4_plus/alter_role_description.sql | 12 - .../roles/tests/9.4_plus/alter_role_name.sql | 12 - .../servers/roles/tests/9.4_plus/create_role.sql | 10 - .../alter_login_role_description.msql | 0 .../alter_login_role_description.sql | 0 .../alter_login_role_name.msql | 0 .../alter_login_role_name.sql | 0 .../alter_login_role_options.msql | 0 .../alter_login_role_options.sql | 0 .../alter_role_description.msql | 0 .../alter_role_description.sql | 0 .../{9.4_plus => default}/alter_role_name.msql | 0 .../{9.1_plus => default}/alter_role_name.sql | 0 .../{9.4_plus => default}/alter_role_options1.msql | 0 .../{9.4_plus => default}/alter_role_options1.sql | 0 .../{9.4_plus => default}/alter_role_options2.msql | 0 .../{9.4_plus => default}/alter_role_options2.sql | 0 .../{9.4_plus => default}/alter_role_options3.msql | 0 .../{9.4_plus => default}/alter_role_options3.sql | 0 .../{9.4_plus => default}/alter_role_options4.msql | 0 .../{9.4_plus => default}/alter_role_options4.sql | 0 .../{9.4_plus => default}/create_login_role.msql | 0 .../{9.4_plus => default}/create_login_role.sql | 0 .../tests/{9.4_plus => default}/create_role.msql | 0 .../tests/{9.1_plus => default}/create_role.sql | 0 .../roles/tests/{9.4_plus => default}/test.json | 0 .../templates/tablespaces/sql/9.2_plus/nodes.sql | 9 - .../tablespaces/sql/9.2_plus/properties.sql | 16 - .../templates/tablespaces/sql/9.2_plus/update.sql | 80 - .../tablespaces/sql/9.6_plus/variables.sql | 4 - .../templates/tablespaces/sql/default/nodes.sql | 2 +- .../tablespaces/sql/default/properties.sql | 10 +- .../templates/tablespaces/sql/default/update.sql | 24 +- .../tablespaces/sql/default/variables.sql | 2 +- .../templates/servers/sql/10_plus/stats.sql | 51 - .../templates/servers/sql/9.2_plus/stats.sql | 49 - .../templates/servers/sql/9.6_plus/stats.sql | 51 - .../templates/servers/sql/default/stats.sql | 18 +- .../templates/dashboard/sql/10_plus/activity.sql | 22 - .../templates/dashboard/sql/9.6_plus/activity.sql | 21 - .../templates/dashboard/sql/default/activity.sql | 6 +- 1093 files changed, 3410 insertions(+), 26868 deletions(-)
