Various procedure/function related fixes for EPAS/PG 11. Fixes #3446
- Fix the RM #3446 "plpgsql keyword should displayed in SQL pane for EPAS-11".
- Procedures for EPAS 11 always created as 'edbspl', even though language is sql or plpgsql.
- Not able to create Function/Procedure/Trigger function if the language is "C" for all supported database server.
- Function creation for EPAS 9.6 and above when set "Window?" flag to "Yes".
- Disable Volatility, Strict, Parallel, Estimated cost and Leak prof while creating procedures in EPAS 11 when language
isnot 'edbspl'.
- Rename "default" folder to "11_plus" inside "pg" directory for procedures, as procedures are supported from PG11
onwards.
- Creating/Deleting parameter in Procedure for PG 11.
- Drop procedures with arguments for PG/EPAS 11.
pg_proc table has added default value 'v' for Volatility, 100 for Cost and 'u' for Parallel for any language. All the
threeare not supported for Procedures in PG/EPAS 11 (excluding 'edbspl' language for EPAS). Fixed the issue where it is
visiblein properties panel if we create procedure using language 'plpgsql' or 'sql'.
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=39b41d7b24a85ede6b5db7741c6e81d53a56b49d
Author: Akshay Joshi <akshay.joshi@enterprisedb.com>
Modified Files
--------------
docs/en_US/release_notes_3_2.rst | 1 +
.../databases/schemas/functions/__init__.py | 28 ++++-
.../schemas/functions/static/js/function.js | 7 +-
.../schemas/functions/static/js/procedure.js | 50 +++++++--
.../function/ppas/sql/9.6_plus/create.sql | 2 +-
.../procedure/pg/sql/{default => 11_plus}/acl.sql | 0
.../pg/sql/{default => 11_plus}/coll_stats.sql | 0
.../pg/sql/{default => 11_plus}/create.sql | 0
.../pg/sql/{default => 11_plus}/delete.sql | 2 +-
.../pg/sql/{default => 11_plus}/get_definition.sql | 0
.../pg/sql/{default => 11_plus}/get_languages.sql | 0
.../pg/sql/{default => 11_plus}/get_oid.sql | 0
.../pg/sql/{default => 11_plus}/get_out_types.sql | 0
.../pg/sql/{default => 11_plus}/get_schema.sql | 0
.../pg/sql/{default => 11_plus}/get_types.sql | 0
.../procedure/pg/sql/{default => 11_plus}/node.sql | 0
.../pg/sql/{default => 11_plus}/properties.sql | 0
.../pg/sql/{default => 11_plus}/stats.sql | 0
.../pg/sql/{default => 11_plus}/update.sql | 9 +-
.../pg/sql/{default => 11_plus}/variables.sql | 0
.../procedure/ppas/sql/11_plus/create.sql | 59 +++++++++++
.../procedure/ppas/sql/11_plus/delete.sql | 2 +-
.../procedure/ppas/sql/11_plus/update.sql | 115 +++++++++++++++++++++
23 files changed, 255 insertions(+), 20 deletions(-)