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

From: Srinath Reddy Sadipiralla <srinath(dot)reddy(at)zohocorp(dot)com>
To: "Heikki Linnakangas" <hlinnaka(at)iki(dot)fi>, "pgsql-hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: \watch 0 or \watch 0.00001 doesn't do what I want
Date: 2024-10-09 14:07:38
Message-ID: 192719b5521.d5ac74b185201.6145494442517942753@zohocorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

---- On Wed, 09 Oct 2024 19:08:56 +0530 Heikki Linnakangas <hlinnaka(at)iki(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Junwang Zhao 2024-10-09 14:10:27 Re: general purpose array_sort
Previous Message Heikki Linnakangas 2024-10-09 14:05:16 Re: Allow default \watch interval in psql to be configured