pgAdmin 4 commit: Various procedure/function related fixes forEPAS/PG
От | Dave Page |
---|---|
Тема | pgAdmin 4 commit: Various procedure/function related fixes forEPAS/PG |
Дата | |
Msg-id | E1ffOOU-0006Cu-BC@gothos.postgresql.org обсуждение исходный текст |
Список | pgadmin-hackers |
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(-)
В списке pgadmin-hackers по дате отправления: