diff options
| author | Michael Paquier <michael@paquier.xyz> | 2020-07-30 15:48:44 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2020-07-30 15:48:44 +0900 |
| commit | 903134fcc0ccd188803fdbc2b7c06b898749153a (patch) | |
| tree | 56e37018b506937e3ae50339395504dc058e1d8f /doc/src | |
| parent | e7591fd3cae6c64236ef29d3c87e69b96608a19b (diff) | |
| download | postgresql-903134fcc0ccd188803fdbc2b7c06b898749153a.tar.gz postgresql-903134fcc0ccd188803fdbc2b7c06b898749153a.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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index a99c681887b..26fda20d193 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -4417,9 +4417,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> @@ -4443,7 +4443,7 @@ SCRAM-SHA-256$<replaceable><iteration count></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> @@ -4453,7 +4453,7 @@ SCRAM-SHA-256$<replaceable><iteration count></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> @@ -4465,6 +4465,10 @@ 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. + </para> + <para> + Indexes can not have multiple inheritance, since they can only inherit + when using declarative partitioning. </para></entry> </row> </tbody> |