Re: [HACKERS] Proposal for async support in libpq

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> This all looks good. Another thing we really need it to be able to
> cancel queries. This would be a big win, and looks like it could fit
> into the scheme here.

I thought about proposing a PQcancelAsync that would cancel the active
query-in-progress. But that would require support on the backend side,
and I am far from competent to make it happen. (libpq is simple enough
that I'm not afraid to rewrite it, but making major mods to the backend
is another story. I just got here this week...)

If anyone who does know what they're doing is willing to make the
necessary backend mods, I'm all for it. The libpq side would be
easy enough.

How would such cancellation interact with transactions, btw? Would
you expect it to roll back only the current command, or abort the
whole transaction? We'd also have to consider corner cases, like
when the backend has already finished the query by the time it gets
the cancel request.

regards, tom lane