1) Added the option 'Show template databases?' to display template databases regardless of the setting of 'Show system
objects?'.
2) Ensure that the user should be able to create a template database using create dialog instead of updating it later.
Fixes #7351
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=628e609e6a5aab9da0ecdcfaaee472b4ff9862ee
Author: Pradip Parkale <pradip.parkale@enterprisedb.com>
Modified Files
--------------
docs/en_US/database_dialog.rst | 1 +
docs/en_US/images/database_definition.png | Bin 72722 -> 68693 bytes
docs/en_US/images/preferences_browser_display.png | Bin 177359 -> 181432 bytes
docs/en_US/preferences.rst | 3 +
docs/en_US/release_notes_6_11.rst | 1 +
web/package.json | 2 +-
web/pgadmin/browser/collection.py | 12 ++
.../browser/register_browser_preferences.py | 7 +
.../server_groups/servers/databases/__init__.py | 71 ++++++++--
.../databases/static/img/template_database.svg | 8 ++
.../databases/static/img/template_database_bad.svg | 10 ++
.../servers/databases/static/js/database.js | 24 +++-
.../servers/databases/static/js/database.ui.js | 8 +-
.../databases/templates/databases/css/database.css | 21 +++
.../databases/sql/10_plus/alter_online.sql | 147 +++++++++++++++++++++
.../templates/databases/sql/10_plus/create.sql | 21 +++
.../templates/databases/sql/10_plus/properties.sql | 37 ++++++
.../templates/databases/sql/default/nodes.sql | 7 +-
.../templates/databases/sql/default/properties.sql | 2 -
.../alter_default_db_privileges_function.sql | 3 +-
.../alter_default_db_privileges_function_msql.sql | 1 -
.../alter_default_db_privileges_reset_all.sql | 3 +-
.../alter_default_db_privileges_sequences.sql | 3 +-
.../default/alter_default_db_privileges_tables.sql | 3 +-
.../default/alter_default_db_privileges_types.sql | 4 +-
.../alter_default_db_privileges_function.sql | 3 +-
.../alter_default_db_privileges_function_msql.sql | 1 -
.../alter_default_db_privileges_reset_all.sql | 3 +-
.../alter_default_db_privileges_sequences.sql | 3 +-
.../default/alter_default_db_privileges_tables.sql | 3 +-
.../default/alter_default_db_privileges_types.sql | 5 +-
.../server_groups/servers/databases/tests/utils.py | 1 +
web/pgadmin/browser/static/js/panel.js | 7 +-
web/pgadmin/misc/sql/static/js/SQL.jsx | 5 +-
web/yarn.lock | 4 +-
35 files changed, 380 insertions(+), 54 deletions(-)