Hi Michael, In this case , I always need to include partition key(date) in primary key ( if I have a primary key defined on non partition key column e.g id (in my case), to make it a composite primary key (id, date). This would allow duplicate id with different date,which is not desirable .
Thanks, Shatamjeev From: Michael Lewis <mle...@entrata.com> Sent: October-07-19 7:18 PM To: Shatamjeev Dewan <sde...@nbsps.com> Cc: pgsql-general <pgsql-gene...@postgresql.org> Subject: Re: Declarative Range Partitioning Postgres 11 No, what you want is not possible and probably won't ever be I would expect. Scanning every partition to validate the primary key isn't scalable.
