pgAdmin 4 commit: Add support for INCLUDE columns on indexes andindex

Add support for INCLUDE columns on indexes and index constraints with PG 11+. Fixes #3462

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c353135a3a312b58e0e5cc7450f056ab7b563ede
Author: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>

Modified Files
--------------
docs/en_US/exclusion_constraint_dialog.rst         |   2 +
docs/en_US/images/exclusion_constraint_columns.png | Bin 58127 -> 53284 bytes
docs/en_US/images/exclusion_constraint_general.png | Bin 38781 -> 37892 bytes
docs/en_US/images/exclusion_constraint_sql.png     | Bin 59890 -> 60618 bytes
docs/en_US/images/index_definition.png             | Bin 76567 -> 60141 bytes
docs/en_US/images/index_sql.png                    | Bin 83738 -> 69499 bytes
docs/en_US/images/primary_key_definition.png       | Bin 53446 -> 60423 bytes
docs/en_US/images/primary_key_sql.png              | Bin 52757 -> 59450 bytes
docs/en_US/images/unique_constraint_definition.png | Bin 64106 -> 61685 bytes
docs/en_US/images/unique_constraint_general.png    | Bin 53840 -> 35947 bytes
docs/en_US/images/unique_constraint_sql.png        | Bin 78556 -> 70419 bytes
docs/en_US/index_dialog.rst                        |   2 +
docs/en_US/primary_key_dialog.rst                  |   1 +
docs/en_US/unique_constraint_dialog.rst            |   1 +
.../constraints/exclusion_constraint/__init__.py   |  30 ++++++-
.../static/js/exclusion_constraint.js              |  98 +++++++++++++++++++++
.../exclusion_constraint/tests/__init__.py         |   8 ++
.../tests/test_exclusion_constraint_add.py         |  80 +++++++++++++++++
.../tests/test_exclusion_constraint_delete.py      |  79 +++++++++++++++++
.../tests/test_exclusion_constraint_get.py         |  69 +++++++++++++++
.../tests/test_exclusion_constraint_put.py         |  77 ++++++++++++++++
.../exclusion_constraint/tests/utils.py            |  89 +++++++++++++++++++
.../tables/constraints/foreign_key/__init__.py     |   2 +-
.../constraints/index_constraint/__init__.py       |  37 ++++++--
.../index_constraint/static/js/primary_key.js      |  98 +++++++++++++++++++++
.../static/js/unique_constraint.js                 |  98 +++++++++++++++++++++
.../databases/schemas/tables/indexes/__init__.py   |  35 +++++++-
.../schemas/tables/indexes/static/js/index.js      |  79 ++++++++++++++++-
.../tables/indexes/tests/test_indexes_add.py       |   4 +-
.../exclusion_constraint/sql/11_plus/create.sql    |  21 +++++
.../sql/11_plus/get_constraint_include.sql         |  16 ++++
.../sql/11_plus/properties.sql                     |  34 +++++++
.../sql/default/properties.sql                     |   4 +-
.../foreign_key/sql/default/get_constraints.sql    |   4 +-
.../templates/index/sql/11_plus/column_details.sql |  31 +++++++
.../tables/templates/index/sql/11_plus/create.sql  |  25 ++++++
.../index/sql/11_plus/include_details.sql          |  16 ++++
.../index_constraint/sql/11_plus/create.sql        |  20 +++++
.../sql/11_plus/get_constraint_include.sql         |  16 ++++
.../index_constraint/sql/11_plus/properties.sql    |  33 +++++++
.../index_constraint/sql/{ => default}/begin.sql   |   0
.../index_constraint/sql/{ => default}/create.sql  |   0
.../index_constraint/sql/{ => default}/delete.sql  |   0
.../index_constraint/sql/{ => default}/end.sql     |   0
.../sql/{ => default}/get_constraint_cols.sql      |   0
.../sql/{ => default}/get_indices.sql              |   0
.../sql/{ => default}/get_name.sql                 |   0
.../index_constraint/sql/{ => default}/get_oid.sql |   0
.../sql/{ => default}/get_oid_with_transaction.sql |   0
.../sql/{ => default}/get_parent.sql               |   0
.../index_constraint/sql/{ => default}/nodes.sql   |   0
.../sql/{ => default}/properties.sql               |   4 +-
.../index_constraint/sql/{ => default}/stats.sql   |   0
.../index_constraint/sql/{ => default}/update.sql  |   0
.../templates/table/sql/macros/constraints.macro   |  20 +++--
.../servers/databases/schemas/tables/utils.py      |  48 +++++++++-
web/pgadmin/tools/sqleditor/__init__.py            |  12 ++-
57 files changed, 1164 insertions(+), 29 deletions(-)