Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ntftU-0001R7-1L for pgsql-hackers@arkaria.postgresql.org; Wed, 25 May 2022 01:33:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ntftS-00016f-Ub for pgsql-hackers@arkaria.postgresql.org; Wed, 25 May 2022 01:32:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ntftS-00016Q-LU for pgsql-hackers@lists.postgresql.org; Wed, 25 May 2022 01:32:58 +0000 Received: from mail-qt1-x82b.google.com ([2607:f8b0:4864:20::82b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ntftL-0002MS-8t for pgsql-hackers@lists.postgresql.org; Wed, 25 May 2022 01:32:57 +0000 Received: by mail-qt1-x82b.google.com with SMTP id s31so556613qtc.3 for ; Tue, 24 May 2022 18:32:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :user-agent; bh=izO7dFGBBWM9HHlyGtSeE7xkN6JSNI8ULvV9HOfeB3U=; b=jBZZvdehg5si4XI1qTnhuwcTO8PNK8VrHaF3vIBbGycYLmZNRKzKo95PxR8YUlSlIs gpPdwh7HS/xLVO3DFwboZ5oJciip5nxV+KwVFVt36tPOSRYma3XEZnr1hDGGEce29tSB oj9JKXpqXy4N2ZbVeREBYHzj5umcJSub1sm9uZrU+hoZIWfkvi/5wAddgNvBhFp+ZyLU g3U1lJYvY2YkzY7IXHzygvkgBxb+jDIIiP0N4iQzQZlAOSZLQmxEfSN3NCmlyGnKI4IW xhYuh2CJ1Ea6vl2oA2QSfIMsxumneb+2EDVEXb7NH9/Owf713FbdG6K9Fcy7ttWnbFIA wsQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:user-agent; bh=izO7dFGBBWM9HHlyGtSeE7xkN6JSNI8ULvV9HOfeB3U=; b=0rL4R9Pb8Hico9vmXl9wZ9la467DWLPez8pG8LYanQLVBaVyULPZA1bEGE3nDAAZzG WSgaisTeNqpXBJqy8h35hsmzYeIBMPq0kksjZPp5+naxoXQnu5UsDeC8qFDKEcS3B1rG 22TH3C1W7elACp07KSGJt2TAuU4wWCIkBsz+o+qTO17cBwOkyFd2s6YYQT503JV88+Ws qYkAenX0BWJTMBz0IoIqJHqh15biUOnivNHvnt6b376NJu42r5tlp6AAotdTywdq7bPD pqrHJUUX0/G1nF4zfTwxbwZ4wl1mT7RbyL9Y8QHBYcLvr6mKygxkaiH+lL8EKtX85nJz 2wsQ== X-Gm-Message-State: AOAM5304k1kHp+4H4RRb0SFLAk4qLBovmWR3I9FKqY/qnHfDG9PppiZH fJiHU3C/LIwiEAs15N+Py9lsMw== X-Google-Smtp-Source: ABdhPJwyiQoxIPTgLfqpSd84YSY9n/kEQzDP3o+p7bH+PaK3YsODs/G0EjyHl40+QACCE0/49/Xnlw== X-Received: by 2002:ac8:5b87:0:b0:2f8:ab4:a050 with SMTP id a7-20020ac85b87000000b002f80ab4a050mr22693801qta.183.1653442370355; Tue, 24 May 2022 18:32:50 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id s19-20020a05620a081300b0069fc13ce22dsm452506qks.94.2022.05.24.18.32.49 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 24 May 2022 18:32:49 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id B5A2780057D; Tue, 24 May 2022 20:32:48 -0500 (CDT) Date: Tue, 24 May 2022 20:32:48 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Amit Langote , David Rowley , Peter Eisentraut , Ashutosh Bapat , pgsql-hackers@lists.postgresql.org, "Shinoda, Noriyoshi (PN Japan FSIP)" , Tomas Vondra Subject: doc phrase: "inheritance child" Message-ID: <20220525013248.GO19626@telsasoft.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="ABTtc+pdwF7KHXCz" Content-Disposition: inline User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --ABTtc+pdwF7KHXCz Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In this old sub-thread, we removed the use of word "partition" when it didn't mean "declarative partitioning". https://www.postgresql.org/message-id/flat/20180601213300.GT5164%40telsasoft.com#32efea8c1aa0e875d201873dac56e09c Now, I'm proposing to get rid of the phrase "inheritance child" when it also *does* apply to declarative partitioning. --ABTtc+pdwF7KHXCz Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-doc-avoid-saying-inheritence-when-it-applies-to-part.patch" From 499fdd3ab35e6a152ae2cada934dfd7df48e7e10 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Mon, 25 Apr 2022 14:59:12 -0500 Subject: [PATCH] doc: avoid saying "inheritence" when it applies to partitioned rels This is almost the opposite of 0c06534bd, which removed references to "partition" for "child". --- doc/src/sgml/catalogs.sgml | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index c00c93dd7be..366a142d35e 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -2135,7 +2135,7 @@ SCRAM-SHA-256$<iteration count>:&l relhassubclass bool - True if table or index has (or once had) any inheritance children + True if table or index has (or once had) any inheritance children or partitions @@ -7306,7 +7306,7 @@ SCRAM-SHA-256$<iteration count>:&l Normally there is one entry, with stainherit = false, for each table column that has been analyzed. - If the table has inheritance children, a second entry with + If the table has inheritance children or partitions, a second entry with stainherit = true is also created. This row represents the column's statistics over the inheritance tree, i.e., statistics for the data you'd see with @@ -7389,7 +7389,7 @@ SCRAM-SHA-256$<iteration count>:&l stainherit bool - If true, the stats include inheritance child columns, not just the + If true, the stats include child tables, not just the values in the specified relation @@ -7661,7 +7661,7 @@ SCRAM-SHA-256$<iteration count>:&l Normally there is one entry, with stxdinherit = false, for each statistics object that has been analyzed. - If the table has inheritance children, a second entry with + If the table has inheritance children or partitions, a second entry with stxdinherit = true is also created. This row represents the statistics object over the inheritance tree, i.e., statistics for the data you'd see with @@ -7715,7 +7715,7 @@ SCRAM-SHA-256$<iteration count>:&l stxdinherit bool - If true, the stats include inheritance child columns, not just the + If true, the stats include child childs, not just the values in the specified relation @@ -13152,7 +13152,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx inherited bool - If true, this row includes inheritance child columns, not just the + If true, this row includes child tables, not just the values in the specified table -- 2.17.1 --ABTtc+pdwF7KHXCz--