pgpartman / pg_partman

Partition management extension for PostgreSQL
Other
2.13k stars 283 forks source link

maintenance_last_run column not present in part_config table #648

Closed sanjay-motorq closed 7 months ago

sanjay-motorq commented 7 months ago

The maintenance_last_run column as mentioned in the documentation is not present in my part_config table. Are there any steps to enable this ? I could not find any further details in the documentation.

sanjay-motorq commented 7 months ago

This is what my part_config table definition looks like. As mentioned, maintenance_last_run is not present

CREATE TABLE partman.part_config (
    parent_table text PRIMARY KEY,
    control text NOT NULL,
    partition_type text NOT NULL CHECK (partman.check_partition_type(partition_type)),
    partition_interval text NOT NULL,
    constraint_cols text[],
    premake integer NOT NULL DEFAULT 4 CHECK (premake > 0),
    optimize_trigger integer NOT NULL DEFAULT 4,
    optimize_constraint integer NOT NULL DEFAULT 30,
    epoch text NOT NULL DEFAULT 'none'::text CHECK (partman.check_epoch_type(epoch)),
    inherit_fk boolean NOT NULL DEFAULT true,
    retention text,
    retention_schema text CHECK (retention_schema <> ''::text),
    retention_keep_table boolean NOT NULL DEFAULT true,
    retention_keep_index boolean NOT NULL DEFAULT true,
    infinite_time_partitions boolean NOT NULL DEFAULT false,
    datetime_string text,
    automatic_maintenance text NOT NULL DEFAULT 'on'::text CHECK (partman.check_automatic_maintenance_value(automatic_maintenance)),
    jobmon boolean NOT NULL DEFAULT true,
    sub_partition_set_full boolean NOT NULL DEFAULT false,
    undo_in_progress boolean NOT NULL DEFAULT false,
    trigger_exception_handling boolean DEFAULT false,
    upsert text NOT NULL DEFAULT ''::text,
    trigger_return_null boolean NOT NULL DEFAULT true,
    template_table text,
    publications text[] CHECK (publications <> '{}'::text[]),
    inherit_privileges boolean DEFAULT false,
    constraint_valid boolean NOT NULL DEFAULT true,
    subscription_refresh text,
    drop_cascade_fk boolean NOT NULL DEFAULT false,
    CONSTRAINT control_constraint_col_chk CHECK ((constraint_cols @> ARRAY[control]) <> true)
);
sanjay-motorq commented 7 months ago

I'm on an older version of partman. Closing the issue.