0

I am using PostgreSQL 12 and wish to use native partitioning only (no inheritance with template table).

I tried partman 4.5.1 to create the partitions for an existing partitioned table.

SELECT partman.create_parent( p_parent_table => 'public.measurement',
 p_control => 'logdate',
 p_type => 'native',
 p_interval=> 'daily',
 p_premake => 5);

Outcome:

  • public schema: new partitions are created.
  • partman schema: there is a new template table.

How can I be sure these partitions do not inherit the template table?

More info:

  • Command \d+ _the_template_table does not show any child tables
  • From partman docs and changelog 4.2.0, it looks like they still rely on the template table for some unsupported features.
Hung Ha
  • 89
  • 1
  • 4

0 Answers0