• Tom Lane's avatar
    Ignore invalid indexes in pg_dump. · 683abc73
    Tom Lane authored
    Dumping invalid indexes can cause problems at restore time, for example
    if the reason the index creation failed was because it tried to enforce
    a uniqueness condition not satisfied by the table's data.  Also, if the
    index creation is in fact still in progress, it seems reasonable to
    consider it to be an uncommitted DDL change, which pg_dump wouldn't be
    expected to dump anyway.
    
    Back-patch to all active versions, and teach them to ignore invalid
    indexes in servers back to 8.2, where the concept was introduced.
    
    Michael Paquier
    683abc73
pg_dump.c 443 KB