Re: Danger of automatic connection reset in psql - Mailing list pgsql-hackers

From Oleksandr Shulgin
Subject Re: Danger of automatic connection reset in psql
Date
Msg-id CACACo5TLTOiZ6_sTpnE-M=pj_uKETV6LWKZyZoaAa0mB63M+tw@mail.gmail.com
Whole thread Raw
In response to Danger of automatic connection reset in psql  (Oleksandr Shulgin <oleksandr.shulgin@zalando.de>)
Responses Re: Danger of automatic connection reset in psql
List pgsql-hackers
On Thu, Oct 20, 2016 at 12:28 PM, Oleksandr Shulgin <oleksandr.shulgin@zalando.de> wrote:

Since this is already an improvement, I'm attaching a patch.

If on the other hand, someone is pasting into psql's terminal a block of commands enclosed in BEGIN/COMMIT, the same bug is triggered: BEGIN doesn't have effect and the rest of commands run outside of transaction.

Is it possible at all to protect against the latter case?  How?

One idea I was just suggested is to make interactive psql sessions buffer in all available input, before it's going to block.  This way it doesn't matter if the multiple statements are appearing on one line or are being pasted.

Feasible?

--
Alex

pgsql-hackers by date:

Previous
From: Oleksandr Shulgin
Date:
Subject: Re: Danger of automatic connection reset in psql
Next
From: Bruce Momjian
Date:
Subject: Re: Indirect indexes