pgAdmin 4 commit: Function and procedure support for PG11. Fixes #3362

Function and procedure support for PG11. Fixes #3362

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=d1ecba56b8d6c70de4e48b344e1d1e56561bbdfe
Author: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>

Modified Files
--------------
docs/en_US/procedure_dialog.rst | 13 ++-
docs/en_US/release_notes_3_1.rst | 5 +-
.../databases/schemas/functions/__init__.py | 10 +-
.../schemas/functions/static/js/procedure.js | 19 ++--
.../function/pg/sql/11_plus/coll_stats.sql | 20 ++++
.../templates/function/pg/sql/11_plus/create.sql | 70 ++++++++++++
.../templates/function/pg/sql/11_plus/delete.sql | 21 ++++
.../function/pg/sql/11_plus/get_definition.sql | 15 +++
.../templates/function/pg/sql/11_plus/get_oid.sql | 17 +++
.../templates/function/pg/sql/11_plus/node.sql | 22 ++++
.../function/pg/sql/11_plus/properties.sql | 33 ++++++
.../templates/function/pg/sql/11_plus/update.sql | 116 ++++++++++++++++++++
.../function/ppas/sql/9.2_plus/create.sql | 2 +-
.../templates/procedure/pg/sql/default/acl.sql | 35 ++++++
.../procedure/pg/sql/default/coll_stats.sql | 20 ++++
.../templates/procedure/pg/sql/default/create.sql | 50 +++++++++
.../templates/procedure/pg/sql/default/delete.sql | 21 ++++
.../procedure/pg/sql/default/get_definition.sql | 15 +++
.../procedure/pg/sql/default/get_languages.sql | 4 +
.../templates/procedure/pg/sql/default/get_oid.sql | 17 +++
.../procedure/pg/sql/default/get_out_types.sql | 6 ++
.../procedure/pg/sql/default/get_schema.sql | 6 ++
.../procedure/pg/sql/default/get_types.sql | 20 ++++
.../templates/procedure/pg/sql/default/node.sql | 29 +++++
.../procedure/pg/sql/default/properties.sql | 39 +++++++
.../templates/procedure/pg/sql/default/stats.sql | 8 ++
.../templates/procedure/pg/sql/default/update.sql | 106 ++++++++++++++++++
.../procedure/pg/sql/default/variables.sql | 6 ++
.../trigger_function/pg/sql/11_plus/coll_stats.sql | 20 ++++
.../trigger_function/pg/sql/11_plus/create.sql | 57 ++++++++++
.../trigger_function/pg/sql/11_plus/delete.sql | 21 ++++
.../pg/sql/11_plus/get_definition.sql | 15 +++
.../trigger_function/pg/sql/11_plus/get_oid.sql | 18 ++++
.../trigger_function/pg/sql/11_plus/node.sql | 23 ++++
.../trigger_function/pg/sql/11_plus/properties.sql | 33 ++++++
.../trigger_function/pg/sql/11_plus/update.sql | 109 +++++++++++++++++++
.../schemas/functions/tests/test_function_add.py | 80 ++++++++++++++
.../functions/tests/test_function_delete.py | 49 +++++++++
.../schemas/functions/tests/test_function_get.py | 49 +++++++++
.../schemas/functions/tests/test_function_put.py | 57 ++++++++++
.../schemas/functions/tests/test_procedure_add.py | 90 ++++++++++++++++
.../functions/tests/test_procedure_delete.py | 56 ++++++++++
.../schemas/functions/tests/test_procedure_get.py | 55 ++++++++++
.../schemas/functions/tests/test_procedure_put.py | 62 +++++++++++
.../functions/tests/test_trigger_func_add.py | 43 ++------
.../functions/tests/test_trigger_func_delete.py | 48 ++-------
.../functions/tests/test_trigger_func_get.py | 51 +++------
.../functions/tests/test_trigger_func_put.py | 58 +++-------
.../databases/schemas/functions/tests/utils.py | 120 +++++++++++++++++++++
web/pgadmin/browser/utils.py | 7 +-
web/pgadmin/tools/debugger/__init__.py | 18 +++-
.../templates/debugger/sql/execute_plpgsql.sql | 4 +-
.../debugger/sql/get_function_debug_info.sql | 8 +-
web/pgadmin/utils/versioned_template_loader.py | 3 +-
54 files changed, 1717 insertions(+), 182 deletions(-)