Can pg_partman create future partitions for tables that didn't have data in the old partitions?

[pm1352]

Is pg_partman supposed to create new partitions even when existing partitions do not contain any data? We use pg_partman to manage both IPv4 and IPv6 tables, which store aggregated customer traffic data. While some customers currently use only IPv4, they may begin using IPv6 at any time, so we want future IPv6 partitions to be created proactively to accommodate this possibility.

Currently, we observe that after the initial creation—which does set up the first IPv6 partitions—pg_partman does not create additional IPv6 partitions, even though new IPv4 partitions are being created as expected. I suspect this is because there is currently no data in the IPv6 tables. However, our goal is to have these partitions available in advance, regardless of whether any data has yet been inserted. Is pg_partman supposed to do this, and if so, why isn't it happening in our setup? I saw in #581 that maybe it didn't create partitions in that case a few years ago, but it's unclear if that issue was fixed and the thread is about 2 years old. Is there a recommended approach or planned feature that would allow pg_partman to create new partitions for tables without existing data?

[keithf4]

It currently does not work when there is zero data and I have no had a chance to look into fixing that.

If there's even a single row of data, however, it should work as expected if infinite_time_partitions is set. That's currently the only work around within pg_partman at this time.