• Heikki Linnakangas's avatar
    Retain comments on indexes and constraints at ALTER TABLE ... TYPE ... · e42375fc
    Heikki Linnakangas authored
    When a column's datatype is changed, ATExecAlterColumnType() rebuilds all
    the affected indexes and constraints, and the comments from the old
    indexes/constraints were not carried over.
    
    To fix, create a synthetic COMMENT ON command in the work queue, to re-add
    any comments on constraints. For indexes, there's a comment field in
    IndexStmt that is used.
    
    This fixes bug #13126, reported by Kirill Simonov. Original patch by
    Michael Paquier, reviewed by Petr Jelinek and me. This bug is present in
    all versions, but only backpatch to 9.5. Given how minor the issue is, it
    doesn't seem worth the work and risk to backpatch further than that.
    e42375fc
alter_table.sql 58.8 KB