• Michael Paquier's avatar
    Preserve opclass parameters across REINDEX CONCURRENTLY · f255de9a
    Michael Paquier authored
    The opclass parameter Datums from the old index are fetched in the same
    way as for predicates and expressions, by grabbing them directly from
    the system catalogs.  They are then copied into the new IndexInfo that
    will be used for the creation of the new copy.
    
    This caused the new index to be rebuilt with default parameters rather
    than the ones pre-defined by a user.  The only way to get back a new
    index with correct opclass parameters would be to recreate a new index
    from scratch.
    
    The issue has been introduced by 911e7020.
    
    Author: Michael Paquier
    Reviewed-by: Zhihong Yu
    Discussion: https://postgr.es/m/YX0CG/QpLXcPr8HJ@paquier.xyz
    Backpatch-through: 13
    f255de9a
create_index.sql 45.9 KB