Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Michael Paquier <michael.paquier@gmail.com>
From: Michael Paquier <michael.paquier@gmail.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Robert Haas <robertmhaas@gmail.com>, Stephen Frost <sfrost@snowman.net>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2017-03-31T04:46:28Z
Lists: pgsql-hackers
Attachments
- pgfdw-partitions-v2.patch (application/octet-stream) patch v2
On Fri, Mar 31, 2017 at 1:37 PM, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> wrote: > + <para> > + For partitioned tables, partitions are automatically excluded from the > + schema data imported. Only the definition of partitioned tables is > included > + to give access to the full data set of all partitions present remotely. > + </para> > + > > Only the definitions of "root" partitioned tables, because when using > multi-level partitioning, there would be partitioned tables that won't be > included (because, relispartition=true). > > If you agree, then this code comment too could use the same terminology: > > + * Ignore table data for partitions and only include the parent > + * definitions to allow access to the complete remote data set > + * locally in the schema imported. > + * That makes sense. Updated this way as I have my hands on it now. -- Michael
Commits
-
postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.
- f49bcd4ef3e9 10.0 landed