• Stephen Frost's avatar
    Add locking clause for SB views for update/delete · 6f9bd50e
    Stephen Frost authored
    In expand_security_qual(), we were handling locking correctly when a
    PlanRowMark existed, but not when we were working with the target
    relation (which doesn't have any PlanRowMarks, but the subquery created
    for the security barrier quals still needs to lock the rows under it).
    
    Noted by Etsuro Fujita when working with the Postgres FDW, which wasn't
    properly issuing a SELECT ... FOR UPDATE to the remote side under a
    DELETE.
    
    Back-patch to 9.4 where updatable security barrier views were
    introduced.
    
    Per discussion with Etsuro and Dean Rasheed.
    6f9bd50e
updatable_views.out 82.8 KB