diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-03-31 15:01:35 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-03-31 15:06:34 -0400 |
| commit | f49bcd4ef3e9a75de210357a4d9bbe3e004db956 (patch) | |
| tree | 1dac9f1a102983c182154bf240732a88df139a70 /doc/src | |
| parent | e306df7f9cd6b4433273e006df11bdc966b7079e (diff) | |
| download | postgresql-f49bcd4ef3e9a75de210357a4d9bbe3e004db956.tar.gz postgresql-f49bcd4ef3e9a75de210357a4d9bbe3e004db956.zip | |
postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.
Don't import partitions. Do import partitioned tables which are
not themselves partitions.
Report by Stephen Frost. Design and patch by Michael Paquier,
reviewed by Amit Langote. Documentation revised by me.
Discussion: http://postgr.es/m/20170309141531.GD9812@tamriel.snowman.net
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/postgres-fdw.sgml | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 7a9b655d366..3dfc0f84ed3 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -425,6 +425,16 @@ For more detail about the treatment of <literal>CHECK</> constraints on foreign tables, see <xref linkend="sql-createforeigntable">. </para> + + <para> + Tables or foreign tables which are partitions of some other table are + automatically excluded. Partitioned tables are imported, unless they + are a partition of some other table. Since all data can be accessed + through the partitioned table which is the root of the partitioning + hierarchy, this approach should allow access to all the data without + creating extra objects. + </para> + </sect3> </sect2> |