If I do something like this:
explain (analyze) select * from pgbench_accounts \watch 1
It behaves as expected. But once I break out of the loop with ctrl-C, then
if I execute the same thing again it executes the command once, but shows
no output and doesn't loop. It seems like some flag is getting set with
ctrl-C, but then never gets reset.
It was broken in this commit:
commit a4fd3aa719e8f97299dfcf1a8f79b3017e2b8d8b
Author: Michael Paquier <mich...@paquier.xyz>
Date: Mon Dec 2 11:18:56 2019 +0900
Refactor query cancellation code into src/fe_utils/
I've not dug into code itself, I just bisected it.
Cheers,
Jeff
