Great point. One of the main reasons we are using partitioning is to quickly drop partitions containing old data so we wouldn't be implementing foreign key constraints any way.
On Fri, 2025-10-24 at 11:54 +1300, David Rowley wrote: > On Fri, 24 Oct 2025 at 09:38, Laurenz Albe <laurenz.albe@cybertec.at> 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.
