Declarative partitioning was new in v10
In v11, it was allowed to create an index on a partitioned table, including
unique indexes.
However it's not a "global" index - instead, it's an "inherited" index.
For a unique index, uniqueness is enforced within each individual index.
And so global uniquen
we have some partitioned tables with inherence and planning to migrate them to
the declaration.
Table DDL:
CREATE TABLE c_account_p
(
billing_account_guid character varying(40) NOT NULL,
ingestion_process_id bigint NOT NULL DEFAULT '-1'::integer,
load_dttm timestamp(6) withou
