Re: \watch 0 or \watch 0.00001 doesn't do what I want

Srinath Reddy Sadipiralla <srinath.reddy@zohocorp.com>

From: Srinath Reddy Sadipiralla <srinath.reddy@zohocorp.com>
To: "Heikki Linnakangas" <hlinnaka@iki.fi>, "pgsql-hackers" <pgsql-hackers@lists.postgresql.org>
Date: 2024-10-09T14:07:38Z
Lists: pgsql-hackers
---- On Wed, 09 Oct 2024 19:08:56 +0530 Heikki Linnakangas <hlinnaka@iki.fi> wrote ---

 
Then I tried setting the delay really small, but that didn't do what I 
wanted either: 
 
postgres=# \watch 0.00001 
Wed 09 Oct 2024 16:36:45 EEST (every 1e-05s) 
 
 ?column? 
---------- 
 1 
(1 row) 
 
^C 
 
It runs the query just once and then hangs forever, until I hit CTRL-C 
to cancel. 
 
hi heikki,but i am in pg 14.7 and the query is running perfectly without getting stuck.

Regards,
Srinath Reddy Sadipiralla
Member Technical Staff
ZOHO

Commits

  1. psql: Fix \watch when using interval values less than 1ms