Skip to content

a new rule is needed: alter index (ATTACH PARTITION) #9

@polymorphm

Description

@polymorphm

Postgresql since version 11 has an ability: partitioned index postgres .

so we need a new rule for it.. and for begin we need at least a DUMP-example :-) .

It seems that the alter rule for ATTACH PARTITION should be with priority mechanism similar as thing in issue #8 .

PG docs look like:

ALTER TABLE ONLY measurement ADD UNIQUE (city_id, logdate);

ALTER TABLE measurement_y2006m02 ADD UNIQUE (city_id, logdate);
ALTER INDEX measurement_city_id_logdate_key
    ATTACH PARTITION measurement_y2006m02_city_id_logdate_key;
...

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions