• Michael Paquier's avatar
    Fix assertion failure with ALTER TABLE ATTACH PARTITION and indexes · 0b48f133
    Michael Paquier authored
    Using ALTER TABLE ATTACH PARTITION causes an assertion failure when
    attempting to work on a partitioned index, because partitioned indexes
    cannot have partition bounds.
    
    The grammar of ALTER TABLE ATTACH PARTITION requires partition bounds,
    but not ALTER INDEX, so mixing ALTER TABLE with partitioned indexes is
    confusing.  Hence, on HEAD, prevent ALTER TABLE to attach a partition if
    the relation involved is a partitioned index.  On back-branches, as
    applications may rely on the existing behavior, just remove the
    culprit assertion.
    
    Reported-by: Alexander Lakhin
    Author: Amit Langote, Michael Paquier
    Discussion: https://postgr.es/m/16276-5cd1dcc8fb8be7b5@postgresql.org
    Backpatch-through: 11
    0b48f133
indexing.out 64.4 KB