default partitions can be partitioned and have default partitions?

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: default partitions can be partitioned and have default partitions?
Date: 2019-09-28 15:18:00
Message-ID: 20190928151800.GK5295@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
...

Not sure how it could be useful to partition default into subpartitions of
lists, ranges, hashes.

Justin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alastair McKinley 2019-09-28 15:33:50 Possible bug: SQL function parameter in window frame definition
Previous Message Fujii Masao 2019-09-28 15:14:44 Re: Document recovery_target_action behavior?