On Fri, 16 Sept 2022 at 19:52, Inzamam Shafiq
<inzamam(dot)shafiq(at)hotmail(dot)com> wrote:
> Is there anyway we can create constraint on column only which are not part of partition key?
Unfortunately, there is no way to create a unique or primary key
constraint unless the constraint contains all columns from the
partition key. This is explained in the limitations section in [1].
If you need such a constraint, then you might want to consider
changing your partition key.
David
[1] https://www.postgresql.org/docs/12/ddl-partitioning.html