• Peter Eisentraut's avatar
    Avoid unnecessary catalog updates in ALTER SEQUENCE · 3d092fe5
    Peter Eisentraut authored
    ALTER SEQUENCE can do nontransactional changes to the sequence (RESTART
    clause) and transactional updates to the pg_sequence catalog (most other
    clauses).  When just calling RESTART, the code would still needlessly do
    a catalog update without any changes.  This would entangle that
    operation in the concurrency issues of a catalog update (causing either
    locking or concurrency errors, depending on how that issue is to be
    resolved).
    
    Fix by keeping track during options parsing whether a catalog update is
    needed, and skip it if not.
    Reported-by: default avatarJason Petersen <jason@citusdata.com>
    3d092fe5
sequence.c 53.9 KB