On 2/3/16 4:25 PM, Tom Lane wrote: > Robert Haas <robertmh...@gmail.com> writes: >> On Wed, Feb 3, 2016 at 3:41 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: >>> Wouldn't it be more sensible to just roll the transaction back and not >>> disconnect? > > I'm not sure how messy this would be in practice. But if we think that > killing the whole session is not desirable but something we're doing for > expediency, then it would be worth looking into that approach.
I think killing the session is a perfectly sensible thing to do in this case. Everything meaningful that was done in the session will be rolled back - no need to waste resources keeping the connection open. -- -David da...@pgmasters.net
Description: OpenPGP digital signature