aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2020-07-30 15:48:52 +0900
committerMichael Paquier <michael@paquier.xyz>2020-07-30 15:48:52 +0900
commite710f3b8e7da43de2ad8113ce7c7933928092656 (patch)
tree1db762752a9458394e6767e608437677e50d4f14
parent78530c8e7a5abe0b646b0b46527f8799f831e1e1 (diff)
downloadpostgresql-e710f3b8e7da43de2ad8113ce7c7933928092656.tar.gz
postgresql-e710f3b8e7da43de2ad8113ce7c7933928092656.zip
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
-rw-r--r--doc/src/sgml/catalogs.sgml14
1 files changed, 9 insertions, 5 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index a15d76a0e93..0709b35c043 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -4416,9 +4416,9 @@ SCRAM-SHA-256$<replaceable>&lt;iteration count&gt;</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>
@@ -4442,7 +4442,7 @@ SCRAM-SHA-256$<replaceable>&lt;iteration count&gt;</replaceable>:<replaceable>&l
(references <link linkend="catalog-pg-class"><structname>pg_class</structname></link>.<structfield>oid</structfield>)
</para>
<para>
- The OID of the child table
+ The OID of the child table or index
</para></entry>
</row>
@@ -4452,7 +4452,7 @@ SCRAM-SHA-256$<replaceable>&lt;iteration count&gt;</replaceable>:<replaceable>&l
(references <link linkend="catalog-pg-class"><structname>pg_class</structname></link>.<structfield>oid</structfield>)
</para>
<para>
- The OID of the parent table
+ The OID of the parent table or index
</para></entry>
</row>
@@ -4464,6 +4464,10 @@ SCRAM-SHA-256$<replaceable>&lt;iteration count&gt;</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.
+ </para>
+ <para>
+ Indexes can not have multiple inheritance, since they can only inherit
+ when using declarative partitioning.
</para></entry>
</row>
</tbody>