Re: Proposed change to make cancellations safe - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposed change to make cancellations safe
Date
Msg-id 6530.1461602065@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposed change to make cancellations safe  (Shay Rojansky <roji@roji.org>)
Responses Re: Proposed change to make cancellations safe  (Shay Rojansky <roji@roji.org>)
List pgsql-hackers
Shay Rojansky <roji@roji.org> writes:
>> Issuing bulk cancellations sounds like a bad plan.

> I'm not sure why, but at the very least it's a useful thing to have when
> batching several statements together and then wanting to cancel them all.

We really do need "cancel up to" semantics for reliable behavior.
Consider the case where the client has sent the query (or thinks it has)
but the server hasn't received it yet.  If the cancel request can arrive
at the server before the query fully arrives, and we don't have "cancel
all messages up through N" semantics, the cancel will not do what the
client expects it to.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Shay Rojansky
Date:
Subject: Re: Proposed change to make cancellations safe
Next
From: Robert Haas
Date:
Subject: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions