On Sun, Sep 29, 2019 at 12:18 AM Justin Pryzby <pry...@telsasoft.com> wrote: > postgres=# CREATE TABLE t(i int)PARTITION BY RANGE(i); > CREATE TABLE > postgres=# CREATE TABLE t0 PARTITION OF t DEFAULT PARTITION BY RANGE(i); > CREATE TABLE > postgres=# CREATE TABLE t00 PARTITION OF t0 DEFAULT; -- oh yes > CREATE TABLE
Actually, you can go even further CREATE TABLE t00 PARTITION OF t0 DEFAULT PARTITION BY HASH (i); > Not sure how it could be useful to partition default into subpartitions of > lists, ranges, hashes. Yeah, maybe the top-level partitioning should be designed such that the default partition doesn't need sub-partitioning, but perhaps Postgres shouldn't prevent users from trying it. This was discussed when the default partition feature went in; see [1]. Thanks, Amit [1] https://www.postgresql.org/message-id/CA%2BTgmoYh-hitRRUfxVxDVAjioYPrjhBCehePGRUa6qNNUnKvuw%40mail.gmail.com
