postgres.git / summary / log / commit / refs
commit 255c707c87339110c04bc7240cf79bceb1a118d3
Author: Michael Paquier <michael@paquier.xyz>
Date: Thu Jul 30 06:49:01 2020 +0000
First released in: 14.0, 11.9, 12.4, 13.0
doc: Mention index references in pg_inherits
Partitioned indexes are also registered in pg_inherits, but the
description of this catalog did not reflect that.
Author: Dagfinn Ilmari Mannsåker
Discussion: https://postgr.es/m/87k0ynj35y.fsf@wibble.ilmari.org
Backpatch-through: 11
doc/src/sgml/catalogs.sgml | 12 +++++++-----
1 file changed, 7 insertions(+), 5 deletions(-)
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index a141576d61b..fdad2cfc613 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -3944,9 +3944,9 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l
<para>
The catalog <structname>pg_inherits</structname> records information about
- table inheritance hierarchies. There is one entry for each direct
- parent-child table relationship in the database. (Indirect inheritance can be determined
- by following chains of entries.)
+ table and index inheritance hierarchies. There is one entry for each direct
+ parent-child table or index relationship in the database. (Indirect
+ inheritance can be determined by following chains of entries.)
</para>
<table>
@@ -3968,7 +3968,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
<entry>
- The OID of the child table
+ The OID of the child table or index
</entry>
</row>
@@ -3977,7 +3977,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
<entry>
- The OID of the parent table
+ The OID of the parent table or index
</entry>
</row>
@@ -3989,6 +3989,8 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l
If there is more than one direct parent for a child table (multiple
inheritance), this number tells the order in which the
inherited columns are to be arranged. The count starts at 1.
+ Indexes can not have multiple inheritance, since they can only inherit
+ when using declarative partitioning.
</entry>
</row>
</tbody>
[parent: 87eb25535d0d]