Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/tcl function to detect when a request has been canceled - Mailing list pgsql-hackers

From Peter Da Silva
Subject Re: pl/tcl function to detect when a request has been canceled
Date
Msg-id DA8FEB43-77DB-4072-9176-0E44A1BB93ED@flightaware.com
Whole thread Raw
In response to Re: pl/tcl function to detect when a request has been canceled  (Andres Freund <andres@anarazel.de>)
Responses Re: pl/tcl function to detect when a request has been canceled
List pgsql-hackers
Tree view 
On 6/8/18, 1:12 PM, "Andres Freund" <andres@anarazel.de> wrote:
    I'm not terribly opposed to this, but I wonder if the much more
    pragmatic solution is to just occasionally call a database function that
    checks this?  You could just run SELECT 1 occasionally :/

After further discussion with our team:

Would this work if the reason for it ignoring the cancel request is that it is already performing a long-running
spi_execwith a large response?

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: SHOW ALL does not honor pg_read_all_settings membership
Next
From: Andres Freund
Date:
Subject: Re: pl/tcl function to detect when a request has been canceled