On Fri, 2025-10-24 at 11:54 +1300, David Rowley wrote: > On Fri, 24 Oct 2025 at 09:38, Laurenz Albe <[email protected]> wrote: > > I recommend that you create a primary key on each partition rather than > > having one > > on the partitioned table. > > It might be worth mentioning that doing that would forego having the > ability to reference the partitioned table in a foreign key > constraint.
Right, but referencing a partitioned table with a foreign key is a mixed blessing anyway: you could no longer drop partitions from the partitioned table without scanning the referencing table to verify that the foreign key is not violated. Yours, Laurenz Albe
