Skip to content
Snippets Groups Projects
  • Neil Conway's avatar
    d13e903b
    RESET SESSION, plus related new DDL commands. Patch from Marko Kreen, · d13e903b
    Neil Conway authored
    reviewed by Neil Conway. This patch adds the following DDL command
    variants: RESET SESSION, RESET TEMP, RESET PLANS, CLOSE ALL, and
    DEALLOCATE ALL. RESET SESSION is intended for use by connection
    pool software and the like, in order to reset a client session
    to something close to its initial state.
    
    Note that while most of these command variants can be executed
    inside a transaction block (but are not transaction-aware!),
    RESET SESSION cannot. While this is inconsistent, it is intended
    to catch programmer mistakes: RESET SESSION in an open transaction
    block is probably unintended.
    d13e903b
    History
    RESET SESSION, plus related new DDL commands. Patch from Marko Kreen,
    Neil Conway authored
    reviewed by Neil Conway. This patch adds the following DDL command
    variants: RESET SESSION, RESET TEMP, RESET PLANS, CLOSE ALL, and
    DEALLOCATE ALL. RESET SESSION is intended for use by connection
    pool software and the like, in order to reset a client session
    to something close to its initial state.
    
    Note that while most of these command variants can be executed
    inside a transaction block (but are not transaction-aware!),
    RESET SESSION cannot. While this is inconsistent, it is intended
    to catch programmer mistakes: RESET SESSION in an open transaction
    block is probably unintended.