Horton

Re: Allow default \watch interval in psql to be configured

Greg Sabino Mullane <htamfids@gmail.com>

View thread View on postgr.es
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Masahiro Ikeda <ikedamsh@oss.nttdata.com>, Kirill Reshke <reshkekirill@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-03-13T14:03:41Z
Lists: pgsql-hackers 
Patch looks good. One minor issue:

greg=# \set WATCH_INTERVAL -1
invalid value "-1" for "WATCH_INTERVAL": must be greater than 0.00
greg=# \set WATCH_INTERVAL 0.00
greg=#

We should disallow 0 as the error message implies

I've long wanted to be able to set the default interval for \watch in psql
> since I almost never want a 2 second wait.


Curious what other's personal defaults are? I usually use 1 second or 0.5
depending on things.


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

Commits

  1. psql: Fix incorrect equality comparison

  2. psql: Make test robust against locale variations

  3. psql: Make default \watch interval configurable