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.