• Alvaro Herrera's avatar
    Implement SKIP LOCKED for row-level locks · df630b0d
    Alvaro Herrera authored
    This clause changes the behavior of SELECT locking clauses in the
    presence of locked rows: instead of causing a process to block waiting
    for the locks held by other processes (or raise an error, with NOWAIT),
    SKIP LOCKED makes the new reader skip over such rows.  While this is not
    appropriate behavior for general purposes, there are some cases in which
    it is useful, such as queue-like tables.
    
    Catalog version bumped because this patch changes the representation of
    stored rules.
    
    Reviewed by Craig Ringer (based on a previous attempt at an
    implementation by Simon Riggs, who also provided input on the syntax
    used in the current patch), David Rowley, and Álvaro Herrera.
    
    Author: Thomas Munro
    df630b0d
outfuncs.c 74.7 KB