Re: postgres_fdw IMPORT SCHEMA and partitioned tables - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Date
Msg-id CAB7nPqSj1xWbkOYt+Cob3S_xYYxam1rN0_bvRVnb0HHMV5iZeg@mail.gmail.com
Whole thread Raw
In response to [HACKERS] postgres_fdw IMPORT SCHEMA and partitioned tables  (Stephen Frost <sfrost@snowman.net>)
Responses Re: postgres_fdw IMPORT SCHEMA and partitioned tables  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Kuntal Ghosh
Date:
Subject: Re: strange parallel query behavior after OOM crashes
Next
From: Craig Ringer
Date:
Subject: Re: Logical decoding on standby