On Sun, 2024-03-24 at 00:37 +0530, veem v wrote: > > Instead, use foreign keys between the partitions. > > I am struggling to understand how to maintain those partitions then? > As because we were planning to use pg_partman for creating and dropping > partitions automatically without much hassle. I understand. But do you want to pursue a way that is not working well, just because the tool you chose cannot handle it? Yours, Laurenz Albe