postgresql.builtin_pool icon indicating copy to clipboard operation
postgresql.builtin_pool copied to clipboard
verified publisher icon postgrespro

discard all will drop all session which mapping to one backend process

Open digoal opened this issue 7 years ago • 1 comments

HI, when i use more connection to pool size. and use one session to execute discard all, then all session which mapping to the same backend process with this session's session variable(sequence, prepared statement,....) will all discard. why not only discard one session's variables?

digoal avatar May 21 '18 02:05 digoal

Sorry, it is expected behavior. Or, in other words, DISCARD command is not currently supported by built-in connection pooler.

knizhnik avatar May 21 '18 19:05 knizhnik