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