, Bolaji Wahab wrote:
> > On Wed, Dec 4, 2024 at 6:20 PM Laurenz Albe
> wrote:
> > > On Wed, 2024-12-04 at 14:22 +0100, Bolaji Wahab wrote:
> > > > I have these two partitioned tables, with referential integrity. The
> tables
> > > > are structured in s
Yes, this is what I have done.
But the whole point of declaring the foreign key constraint on the
partitioned table is to have it automatically created on subsequent/future
partitions.
On Wed, Dec 4, 2024 at 6:20 PM Laurenz Albe
wrote:
> On Wed, 2024-12-04 at 14:22 +0100, Bolaji Wahab wr
Hi team,
I have these two partitioned tables, with referential integrity. The tables
are structured in such a way that we have 1 to 1 mapping between their
partitions. This is achieved with a foreign key.
```
CREATE TABLE parent (
partition_date date NOT NULL,
id uuid NOT NULL,
extern
