Re: Partitioning Tables - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Partitioning Tables
Date
Msg-id CAKFQuwY_hC408Jm6ZHCWHhzrO1brMfnStSTnfa4++L3ci8pCFQ@mail.gmail.com
Whole thread Raw
In response to Re: Partitioning Tables  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
On Friday, February 5, 2021, Campbell, Lance <lance@illinois.edu> wrote:

It does look like it would work if I added the "type" from the group table to the group_member table.  But otherwise the PARITION BY LIST does not support referencing a parent table.

Replace “parent table”  with “some random table only related to the table in question by a foreign key” and it probably will make more sense.

David J.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Partitioning Tables
Next
From: Nikolay Samokhvalov
Date:
Subject: Re: wal-g (https://github.com/wal-g/wal-g) reliability