Attached is the patch to support INCLUDE clause for indexes which is added from Postgres 11. As per Postgres 11 docs, INCLUDE clause is supported for Unique Key, Primary Key, Exclusion constraint and Normal Indexes.
The patch also includes python test cases for Exclusion constraint and small fix in SQL Editor module where the test case ExtractSQLFromNetworkParametersTest was failing for me due on Python 2.7.
Kindly review.
I spotted a couple of issues whilst testing this:
- There are no doc updates and updated screenshots.
- There's some indenting issue in the CREATE TABLE SQL (see how the INCLUDE line is doubly-indented), e.g.
-- Table: public.t1
-- DROP TABLE public.t1;
CREATE TABLE public.t1
(
id bigint NOT NULL DEFAULT nextval('t1_id_seq'::regclass),