part_config


Columns

Column Type Size Nulls Auto Default Children Parents Comments
parent_table text 2147483647 null
part_config_sub.sub_parent part_config_sub_sub_parent_fkey C
control text 2147483647 null
partition_type text 2147483647 null
partition_interval text 2147483647 null
constraint_cols _text 2147483647 √ null
premake int4 10 4
optimize_trigger int4 10 4
optimize_constraint int4 10 30
epoch text 2147483647 'none'::text
inherit_fk bool 1 true
retention text 2147483647 √ null
retention_schema text 2147483647 √ null
retention_keep_table bool 1 true
retention_keep_index bool 1 true
infinite_time_partitions bool 1 false
datetime_string text 2147483647 √ null
automatic_maintenance text 2147483647 'on'::text
jobmon bool 1 true
sub_partition_set_full bool 1 false
undo_in_progress bool 1 false
trigger_exception_handling bool 1 √ false
upsert text 2147483647 ''::text
trigger_return_null bool 1 true
template_table text 2147483647 √ null
publications _text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
part_config_parent_table_pkey Primary key Asc parent_table
part_config_type_idx Performance Asc partition_type

Check Constraints

Constraint Name Constraint
part_config_type_check (check_partition_type(partition_type))
publications_no_empty_set_chk ((publications <> '{}'::text[]))
part_config_epoch_check (check_epoch_type(epoch))
positive_premake_check ((premake > 0))
control_constraint_col_chk (((sub_constraint_cols @> ARRAY[sub_control]) <> true))
part_config_automatic_maintenance_check (check_automatic_maintenance_value(automatic_maintenance))
retention_schema_not_empty_chk ((sub_retention_schema <> ''::text))

Relationships

Close relationships within degrees of separation