Added support for expression in exclusion constraints. Fixes #5571
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=5448de2d3ff3ef486f21ed1be92b4b54a795ca45
Author: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Modified Files
--------------
docs/en_US/exclusion_constraint_dialog.rst | 16 +--
docs/en_US/images/exclusion_constraint_columns.png | Bin 52476 -> 95416 bytes
docs/en_US/images/exclusion_constraint_sql.png | Bin 48863 -> 75488 bytes
docs/en_US/release_notes_4_30.rst | 1 +
.../servers/databases/schemas/tables/__init__.py | 17 ++-
.../constraints/exclusion_constraint/__init__.py | 52 +--------
.../static/js/exclusion_constraint.js | 123 ++++++++++++++-------
.../11_plus/create_exclusion_constraint_exp.sql | 14 +++
.../exclusion_constraint/tests/11_plus/test.json | 40 +++++++
.../default/create_exclusion_constraint_exp.sql | 14 +++
.../exclusion_constraint/tests/default/test.json | 46 +++++++-
.../constraints/exclusion_constraint/utils.py | 6 +-
.../exclusion_constraint/sql/11_plus/create.sql | 2 +-
.../sql/9.2_plus/get_constraint_cols.sql | 5 +-
.../sql/9.2_plus/get_operator.sql | 8 +-
.../exclusion_constraint/sql/default/create.sql | 2 +-
.../sql/default/get_constraint_cols.sql | 3 +-
.../sql/default/get_operator.sql | 8 +-
web/pgadmin/static/js/backform.pgadmin.js | 8 +-
19 files changed, 248 insertions(+), 117 deletions(-)