Hi,
I am trying to create a table in postgres 11 with timestamp column as a partition key using PARTITION BY RANGE (create_dtt). The table definition has also an id column which is a primary key.
ERROR: insufficient columns in PRIMARY KEY constraint definition
DETAIL: PRIMARY KEY constraint on table "audit_p" lacks column "create_dtt" which is part of the partition key.
I don’t want partition key column : create_dtt to part of composite primary key. Is there any way I can create range partition on date column without including as part of primary key .
Please advise.
Thanks,
Shatamjeev