Re: DOCS - "\d mytable" also shows any publications that publish mytable

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: DOCS - "\d mytable" also shows any publications that publish mytable
Date: 2026-01-22 06:14:54
Message-ID: CAHut+PtSoxNpusHa6yq=ad0mAOL1cxD3nh8OEPgkVhVbdpcHJA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jan 22, 2026 at 2:24 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>
...
>
> - table, the view definition if the relation is a view, a non-default
> - <link linkend="sql-altertable-replica-identity">replica
> - identity</link> setting and the
> + table, any partition tables, the view definition if the relation is a
> + view, a non-default <link linkend="sql-altertable-replica-identity">
> + replica identity</link> setting and the
>
> This part doesn't seem to list all possible objects, so it would be better to
> add wording like "for example" or "such as".

OK. Reworded it like that

>
> If this is meant to be illustrative rather than exhaustive, I'm not sure
> we need to add a new item like "any partition tables" this time here.
>

OK. Removed.

> Regarding whole patch, I'm not clear about whether this patch is worthwhile
> if it only adds phrasing like "such as" or "for example". That said, if some
> users currently interpret the list as exhaustive, this change could help
> clarify the intent...
>

Yes. The patch is not doing much now, but OTOH the reason for this
patch adding the "missing" publication entry in the first place was
precisely because I thought the docs page was was documenting
exhaustive lists; so there might be some merit to clear up that
illusion.

> If we decide to commit this change, it seems fine not to backpatch it,
> since it's more of a documentation clarification than a clear bug fix.
>

Agree.

~~~

PSA v4.

======
Kind Regards,
Peter Smith
Fujitsu Australia

Attachment Content-Type Size
v4-0001-DOCS-psql-describe-table-can-list-publications.patch application/octet-stream 2.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-01-22 06:23:20 Re: CREATE TABLE LIKE INCLUDING POLICIES
Previous Message Andrey Borodin 2026-01-22 06:09:37 Re: Likely undefined behavior with some flexible arrays