• Tom Lane's avatar
    Remove unnecessary opening of other relation in RI_FKey_keyequal_upd_pk · cf59277a
    Tom Lane authored
    and RI_FKey_keyequal_upd_fk, as well as no-longer-needed calls of
    ri_BuildQueryKeyFull.  Aside from saving a few cycles, this avoids needless
    deadlock risks when an update is not changing the columns that participate
    in an RI constraint.  Per a gripe from Alexey Nalbat.
    
    Back-patch to 8.3.  Earlier releases did have a need to open the other
    relation due to the way in which they retrieved information about the RI
    constraint, so this problem unfortunately can't easily be improved pre-8.3.
    
    Tom Lane and Stephan Szabo
    cf59277a
ri_triggers.c 105 KB