Date: Mon, 14 Oct 2024 19:15:50 -0400
From: Bruce Momjian <bruce@momjian.us>
To: g***@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Add mention to related system catalog functions on Tablespaces
 documentation pages.
Message-ID: <Zw2mJoNMpyS-aNkl@momjian.us>
References: <172609721070.1128084.6724666076293146476@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <172609721070.1128084.6724666076293146476@wrigleys.postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/Zw2mJoNMpyS-aNkl%40momjian.us>
Precedence: bulk

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  <bruce@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?"