| From: | Peter Smith <smithpb2250(at)gmail(dot)com> |
|---|---|
| To: | Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Should we say "wal_level = logical" instead of "wal_level >= logical" |
| Date: | 2025-11-04 01:43:06 |
| Message-ID: | CAHut+PuA4gSb+cc=833o7dsyFJ+aRmL6XJwUaWM5JK0UfxT+dQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Oct 29, 2025 at 8:10 PM Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
...
> I think 0001 basically good. A tiny comment is that, in inval.c, "wal_level>=logical” doesn’t have white-spaces around “=“, while in the other two files, they have. So maybe all add white-spaces around “=“ here.
>
> For 0002, I have a fixed feeling.
>
> This change is okay to me:
> ```
> - if (wal_level != WAL_LEVEL_LOGICAL)
> + if (wal_level < WAL_LEVEL_LOGICAL)
> ```
>
> But I really don’t like the error message changes:
> ```
> if (nslots_on_old > 0 && strcmp(wal_level, "logical") != 0)
> - pg_fatal("\"wal_level\" must be \"logical\" but is set to \"%s\"",
> + pg_fatal("\"wal_level\" must be \"logical\" or higher but is set to \"%s\"",
> ```
> And
> ```
> -HINT: Set "wal_level" to "logical" before creating subscriptions.
> +HINT: Set "wal_level" >= "logical" before creating subscriptions.
> ```
>
> Which will really make end users confused. I believe end users don’t care about so-called future extensions, they only need accurate information.
>
Hi Chao.
Thanks for your review comments. Here are the v3* patches.
* Patch 0001 - Fixed spaces per suggestion.
* Patch 0002 - Unchanged. For now, this patch 0002 is mostly only a
placeholder until Sawada-San's patch [1] is pushed, and then I will
revisit it. There is lots of overlap, so perhaps much of it will be
made redundant.
Kind Regards,
Peter Smith.
Fujitsu Australia
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0002-fix-wal_level-equality-code.patch | application/octet-stream | 3.1 KB |
| v3-0001-fix-wal_level-equality-comments.patch | application/octet-stream | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Smith | 2025-11-04 02:44:18 | Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis |
| Previous Message | Shinya Kato | 2025-11-04 01:29:26 | Re: Report oldest xmin source when autovacuum cannot remove tuples |