> On Sep 27, 2024, at 21:25, Durgamahesh Manne <maheshpostgr...@gmail.com> > wrote: > > Can't we use primary key on singal column(betid) on partitioned table rather > than using composite key (placedon,betid)? No. Any unique constraint on a partitioned table must include the partition key, including a primary key constraint.
- Regarding use of single column as primary key on partiti... Durgamahesh Manne
- Re: Regarding use of single column as primary key o... David G. Johnston
- Re: Regarding use of single column as primary k... Ron Johnson
- Re: Regarding use of single column as prima... Tom Lane
- Re: Regarding use of single column as p... Ron Johnson
- Re: Regarding use of single column as primary key o... Christophe Pettus