On Wed, Mar 23, 2016 at 10:05 PM, Thom Brown <t...@linux.com> wrote: > I've noticed that you now can't cancel a query if there's DML pushdown > to a foreign server. This previously worked while it was sending > individual statements as it interrupted and rolled it back. > > Here's what the local server sees when trying to cancel: > > # DELETE FROM remote.contacts; > ^CCancel request sent > DELETE 5000000 > > This should probably be fixed.
Looking at what has been committed, execute_dml_stmt is using PQexecParams, so we'd want to use an asynchronous call and loop on PQgetResult with CHECK_FOR_INTERRUPTS() in it. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
