pgsql: psql: add an optional execution-count limit to \watch.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql: add an optional execution-count limit to \watch.
Date: 2023-04-06 17:18:30
Message-ID: E1pkTFl-001hzA-LR@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

psql: add an optional execution-count limit to \watch.

\watch can now be told to stop after N executions of the query.

With the idea that we might want to add more options to \watch
in future, this patch generalizes the command's syntax to a list
of name=value options, with the interval allowed to omit the name
for backwards compatibility.

Andrey Borodin, reviewed by Kyotaro Horiguchi, Nathan Bossart,
Michael Paquier, Yugo Nagata, and myself

Discussion: https://postgr.es/m/CAAhFRxiZ2-n_L1ErMm9AZjgmUK=qS6VHb+0SaMn8sqqbhF7How@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/00beecfe839c878abb366b68272426ed5296bc2b

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 10 +++-
src/bin/psql/command.c | 118 +++++++++++++++++++++++++++++++------
src/bin/psql/help.c | 2 +-
src/bin/psql/t/001_basic.pl | 33 ++++++++---
src/test/regress/expected/psql.out | 2 +-
src/test/regress/sql/psql.sql | 2 +-
6 files changed, 135 insertions(+), 32 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2023-04-06 18:11:02 pgsql: hio: Relax rules for calling GetVisibilityMapPins()
Previous Message Justin Pryzby 2023-04-06 16:39:47 Re: lz4 --rm on Ubuntu 18.04 (Add LZ4 compression to pg_dump)

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2023-04-06 17:18:34 Re: Should vacuum process config file reload more often
Previous Message Kirk Wolak 2023-04-06 17:17:23 Re: Schema variables - new implementation for Postgres 15