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(-)