pgAdmin 4 commit: Added support for expression in exclusion constraints

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 commit: Added support for expression in exclusion constraints
Date: 2020-12-24 07:44:04
Message-ID: E1ksLI4-0004Ea-I0@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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(dot)toshniwal(at)enterprisedb(dot)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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2020-12-24 07:44:49 Re: [pgAdmin][RM5571] Expression in exclusion constraint is misinterpreted and quoted as column name by mistake
Previous Message Rahul Shirsat 2020-12-23 14:52:44 Re: [pgAdmin] RM4892 pgAdmin "Inception"