• Tom Lane's avatar
    Clean up after erroneous SELECT FOR UPDATE/SHARE on a sequence. · ea6eda64
    Tom Lane authored
    My previous commit disallowed this operation, but did nothing about
    cleaning up the damage if one had already been done.  With the operation
    disallowed, it's okay to just forcibly clear xmax in a sequence's tuple,
    since any value seen there could not represent a live transaction's lock.
    So, any sequence-specific operation will repair the problem automatically,
    whether or not the user has already seen "could not access status of
    transaction" failures.
    ea6eda64
sequence.c 41.2 KB