• Stephen Frost's avatar
    Avoid incorrectly indicating exclusion constraint wait · fd658dbb
    Stephen Frost authored
    INSERT ... ON CONFLICT's precheck may have to wait on the outcome of
    another insertion, which may or may not itself be a speculative
    insertion.  This wait is not necessarily associated with an exclusion
    constraint, but was always reported that way in log messages if the wait
    happened to involve a tuple that had no speculative token.
    
    Initially discovered through use of ON CONFLICT DO NOTHING, where
    spurious references to exclusion constraints in log messages were more
    likely.
    
    Patch by Peter Geoghegan.
    Reviewed by Julien Rouhaud.
    
    Back-patch to 9.5 where INSERT ... ON CONFLICT was added.
    fd658dbb
execIndexing.c 28.5 KB