Re: psql's \watch is broken

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: psql's \watch is broken
Date: 2019-12-13 23:09:51
Message-ID: alpine.DEB.2.21.1912140009070.31008@pseudo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 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 <michael(at)paquier(dot)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.

Thanks for the report. I'll look into it.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2019-12-13 23:32:30 Re: xlog.c variable pointlessly global
Previous Message Tom Lane 2019-12-13 23:09:21 Re: Errors "failed to construct the join relation" and "failed to build any 2-way joins"