inconsistent quoting in error messages

Started by Kyotaro Horiguchiover 1 year ago2 messages
#1Kyotaro Horiguchi
horikyota.ntt@gmail.com

I noticed that there are slightly inconsistent messages regarding
quoting policies.

This happens if you temporarily set "wal_level=minimal" on the server.
WAL generated with "full_page_writes=off" was replayed during online backup

pg_log_standby_snapshot() can only be used if "wal_level" >= "replica"

WAL streaming ("max_wal_senders" > 0) requires "wal_level" to be "replica" or "logical"

I think it's best to quote variable names and values separately, like
"wal_level" = "minimal" (but not use quotes for numeric values), as it
seems to be the most common practice. Anyway, we might want to unify
them.

Likewise, I saw two different versions of values with units.

"max_stack_depth" must not exceed %ldkB.
"vacuum_buffer_usage_limit" must be 0 or between %d kB and %d kB

I'm not sure, but it seems like the latter version is more common.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

#2Peter Smith
smithpb2250@gmail.com
In reply to: Kyotaro Horiguchi (#1)
Re: inconsistent quoting in error messages

On Tue, May 21, 2024 at 2:56 PM Kyotaro Horiguchi
<horikyota.ntt@gmail.com> wrote:

I noticed that there are slightly inconsistent messages regarding
quoting policies.

This happens if you temporarily set "wal_level=minimal" on the server.
WAL generated with "full_page_writes=off" was replayed during online backup

pg_log_standby_snapshot() can only be used if "wal_level" >= "replica"

WAL streaming ("max_wal_senders" > 0) requires "wal_level" to be "replica" or "logical"

I think it's best to quote variable names and values separately, like
"wal_level" = "minimal" (but not use quotes for numeric values), as it
seems to be the most common practice. Anyway, we might want to unify
them.

Likewise, I saw two different versions of values with units.

"max_stack_depth" must not exceed %ldkB.
"vacuum_buffer_usage_limit" must be 0 or between %d kB and %d kB

I'm not sure, but it seems like the latter version is more common.

regards.

Hi,

I think it might be better to keep all the discussions about GUC
quoting and related topics like this confined to the main thread here
[1]: /messages/by-id/CAHut+Pv-kSN8SkxSdoHano_wPubqcg5789ejhCDZAcLFceBR-w@mail.gmail.com

======
[1]: /messages/by-id/CAHut+Pv-kSN8SkxSdoHano_wPubqcg5789ejhCDZAcLFceBR-w@mail.gmail.com

Kind Regards,
Peter Smith.
Fujitsu Australia