different partition types for parent and sub partitions

[walkerline]

Hi,

I want to create a structure where the parent table is partitioned by range, but sub partition of the parent partition is partitioned by list.

So this is my table

CREATE TABLE orders_varchar_8 ( created_at DATE NOT NULL, region_name varchar(4) NOT NULL ) PARTITION BY RANGE (created_at);

And first level I was able to use creat_parent() to create parent partition by date... now I want to create sub partitions by region_name which is a text field. However I don't see a way to use create_sub_parent() to achieve this.

Any suggestion would be appreciated.

Also, seems like the template cannot be applied for creating partitions. Is it a bug? The partitions always use the parent table as the format. i use version 5.1.0

[keithf4]

So partman was primarily designed for partitioning methods that require continuous maintenance based on time or integers. While the top level does require continuous maintenance, I haven't developed any way for sub-partitions that aren't also based on time or integers.

I'm not quite sure how I'd handle it at this point. Perhaps a feature to inherit from the template somehow. I'll have to think on it a bit.

I'm open to PRs for ideas!

[walkerline]

Thanks, in my case ,the sub-partitions also requires continuous maintenance. For example if i have a product table and product name(text) is my sub-partition, then when new product is created, we expect a subpartition based on product can be created automatically by partman.

Also, im wondering why when I create parent partition, the template does not seem to be working. The partitions created are not using template format, but with using the parent table format.

[keithf4]

The template table is basically just a stop-gap to help support features that are not supported in core PostgreSQL. Only those unsupported features are inherited from the template. All other partitioning features work as they would in core. See this table in the documentation

https://github.com/pgpartman/pg_partman/blob/development/doc/pg_partman.md#child-table-property-inheritance