Skip to content
Snippets Groups Projects
  • Tom Lane's avatar
    ecfd9941
    Fix SPI documentation for new handling of ExecutorRun's count parameter. · ecfd9941
    Tom Lane authored
    Since 9.0, the count parameter has only limited the number of tuples
    actually returned by the executor.  It doesn't affect the behavior of
    INSERT/UPDATE/DELETE unless RETURNING is specified, because without
    RETURNING, the ModifyTable plan node doesn't return control to execMain.c
    for each tuple.  And we only check the limit at the top level.
    
    While this behavioral change was unintentional at the time, discussion of
    bug #6572 led us to the conclusion that we prefer the new behavior anyway,
    and so we should just adjust the docs to match rather than change the code.
    Accordingly, do that.  Back-patch as far as 9.0 so that the docs match the
    code in each branch.
    ecfd9941
    History
    Fix SPI documentation for new handling of ExecutorRun's count parameter.
    Tom Lane authored
    Since 9.0, the count parameter has only limited the number of tuples
    actually returned by the executor.  It doesn't affect the behavior of
    INSERT/UPDATE/DELETE unless RETURNING is specified, because without
    RETURNING, the ModifyTable plan node doesn't return control to execMain.c
    for each tuple.  And we only check the limit at the top level.
    
    While this behavioral change was unintentional at the time, discussion of
    bug #6572 led us to the conclusion that we prefer the new behavior anyway,
    and so we should just adjust the docs to match rather than change the code.
    Accordingly, do that.  Back-patch as far as 9.0 so that the docs match the
    code in each branch.
spi.sgml 111.57 KiB