default partitions can be partitioned and have default partitions? - Mailing list pgsql-hackers

From Justin Pryzby
Subject default partitions can be partitioned and have default partitions?
Date
Msg-id 20190928151800.GK5295@telsasoft.com
Whole thread Raw
Responses Re: default partitions can be partitioned and have default partitions?
List 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



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Document recovery_target_action behavior?
Next
From: David Steele
Date:
Subject: Re: Standby accepts recovery_target_timeline setting?