Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qjjZc-00Brho-2C for pgsql-docs@arkaria.postgresql.org; Fri, 22 Sep 2023 17:04:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qjjZa-005712-8j for pgsql-docs@arkaria.postgresql.org; Fri, 22 Sep 2023 17:04:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qjjZa-00570p-08 for pgsql-docs@lists.postgresql.org; Fri, 22 Sep 2023 17:04:10 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qjjZW-006xmG-Qp for pgsql-docs@lists.postgresql.org; Fri, 22 Sep 2023 17:04:09 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 38MH42KG1016845; Fri, 22 Sep 2023 13:04:02 -0400 From: Tom Lane To: Daniel Gustafsson cc: mpnash@google.com, pgsql-docs@lists.postgresql.org Subject: Re: Typo/wording on https://www.postgresql.org/docs/current/catalog-pg-class.html In-reply-to: <520464.1695217750@sss.pgh.pa.us> References: <169518739902.3727338.4793815593763320945@wrigleys.postgresql.org> <520464.1695217750@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Wed, 20 Sep 2023 09:49:10 -0400" MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----- =_aaaaaaaaaa0" Content-ID: <1016721.1695402148.0@sss.pgh.pa.us> Date: Fri, 22 Sep 2023 13:04:02 -0400 Message-ID: <1016844.1695402242@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------- =_aaaaaaaaaa0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1016721.1695402148.1@sss.pgh.pa.us> I wrote: > "Most" here is good English, although I concede it's a slightly > old-fashioned usage. Maybe it'd be clearer to just remove the > word altogether. > If we were going to touch this sentence I'd worry about some other > things too. Use of "catalogs" as a verb is probably not the greatest > choice right here, since one could easily think that the verb is > missing and what was meant was "pg_class lists catalogs, [user] > tables, and ...". Also, I think that the reference to special > relations is obsolete --- we don't list any relkind for that anymore. > What probably does deserve to be called out in place of those is > composite types, since their appearance in pg_class might be pretty > surprising to newbies. Hmm, I must have been looking at some old version of the docs, because when I went to prepare a draft patch I found that those last couple of points were addressed some time ago. I think we just need some slightly better wording here rather than any change of technical content. I propose the attached. (I also modified the para's last sentence to speak of "kind" not "type", for consistency with the relkind field name and the rest of the para.) regards, tom lane ------- =_aaaaaaaaaa0 Content-Type: text/x-diff; name="tweak-description-of-pg_class.patch"; charset="us-ascii" Content-ID: <1016721.1695402148.2@sss.pgh.pa.us> Content-Description: tweak-description-of-pg_class.patch Content-Transfer-Encoding: quoted-printable diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index d17ff51e28..e09adb45e4 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1893,8 +1893,8 @@ SCRAM-SHA-256$<iteration count>:&l = - The catalog pg_class catalogs tables and most - everything else that has columns or is otherwise similar to a + The catalog pg_class describes tables and + other objects that have columns or are otherwise similar to a table. This includes indexes (but see also pg_index)= , sequences (but see also <iteration count>:&l views, materialized views, composite types, and TOAST tables; see relkind. Below, when we mean all of these kinds of objects we speak of - relations. Not all columns are meaningful for all rela= tion - types. + relations. Not all of pg_class's + columns are meaningful for all relation kinds. = ------- =_aaaaaaaaaa0--