On Wed, Sep 11, 2024 at 11:26:50PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/manage-ag-tablespaces.html > Description: > > The tablespaces documentation page seems to be missing a mention to the > following functions: > pg_tablespace_databases > pg_tablespace_location > > These are documented in > https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-CATALOG, > but I think it would be nice to add at least a brief mention (or link) to > them in the main tablespace docs. The following query is especially helpful > when troubleshooting issues with tablespaces: > > postgres=# SELECT *, pg_tablespace_location(oid) FROM pg_tablespace; > > It would be beneficial, in my opinion, to use it as an additional example to > the one that is currently shown.
Yes, very good points. I have developed the attached patch which I think achieves the goals you mentioned. I plan to apply the patch for master/PG 18. I also removed the unnecessary mention of PG 9.1. Seems the reply email address is g***@gmail.com, which seems like some kind of mistake. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com When a patient asks the doctor, "Am I going to die?", he means "Am I going to die soon?"
