Re: Possibly hard-to-read message

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Possibly hard-to-read message
Date: 2025-06-05 11:14:48
Message-ID: c34a650b-6f8b-4da7-9ebb-b6df03ce009d@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 07.04.25 02:55, Daniel Gustafsson wrote:
>> On 7 Apr 2025, at 02:43, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> How about:
>>
>> + " if set to a number, overrides the default two second \\watch interval\n"
>>
>> I do like the consistency of "if set" even though most of the others are booleans.
>
> Ah yes, number is better. I'll go ahead with that in the morning.

I came across this psql help text and had a hard time processing it,
and, without having read this thread, my thought process was that the
message should be phrased more like how it was originally.

The problem with the current phrasing is:

- "if set to a number" seems to indicate that something else happens if
it's not a number. But it doesn't say what. And it's also not true.
And we don't phrase things like that for other numeric settings.

- The way this is phrased now seems to say that the variable is unset by
default, and only if it is set does it override the default. But that
is not what happens. The variable has a value by default, and that is
what gets used.

I suggest something like this:

number seconds \watch waits between executions (in seconds, default %d)

While we're here, the documentation could also use some more detail:

<varlistentry id="app-psql-variables-watch-interval">
<term><varname>WATCH_INTERVAL</varname></term>
<listitem>
<para>
This variable sets the default interval which
<command>\watch</command>
waits between executing the query. Specifying an interval in the
command overrides this variable.
</para>
</listitem>
</varlistentry>

This mentions neither the units nor the default value.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dagfinn Ilmari Mannsåker 2025-06-05 11:22:58 Re: add function for creating/attaching hash table in DSM registry
Previous Message Peter Eisentraut 2025-06-05 10:49:08 Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them