pgAdmin 4 commit: Various procedure/function related fixes for EPAS/PG

From: Dave Page <dpage(at)pgadmin(dot)org>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin 4 commit: Various procedure/function related fixes for EPAS/PG
Date: 2018-07-17 11:43:50
Message-ID: E1ffOOU-0006Cu-BC@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 is not '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 three are not supported for Procedures in PG/EPAS 11 (excluding 'edbspl' language for EPAS). Fixed the issue where it is visible in 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(dot)joshi(at)enterprisedb(dot)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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2018-07-17 11:43:58 Re: [pgAdmin4][Patch]: RM #3446 plpgsql keyword should displayed in SQL pane for EPAS-11
Previous Message Dave Page 2018-07-17 11:18:41 pgAdmin 4 commit: Add hints for the config options.