• Fujii Masao's avatar
    postgres_fdw: Allow partitions specified in LIMIT TO to be imported. · a3740c48
    Fujii Masao authored
    Commit f49bcd4e disallowed postgres_fdw to import table partitions.
    Because all data can be accessed through the partitioned table which
    is the root of the partitioning hierarchy, importing only partitioned
    table should allow access to all the data without creating extra objects.
    This is a reasonable default when importing a whole schema. But there
    may be the case where users want to explicitly import one of
    a partitioned tables' partitions.
    
    For that use case, this commit allows postgres_fdw to import tables or
    foreign tables which are partitions of some other table only when they
    are explicitly specified in LIMIT TO clause.  It doesn't change
    the behavior that any partitions not specified in LIMIT TO are
    automatically excluded in IMPORT FOREIGN SCHEMA command.
    
    Author: Matthias van de Meent
    Reviewed-by: Bernd Helmle, Amit Langote, Michael Paquier, Fujii Masao
    Discussion: https://postgr.es/m/CAEze2Whwg4i=mzApMe+PXxCEfgoZmHGqdqQFW7J4bmj_5p6t1A@mail.gmail.com
    a3740c48
postgres_fdw.c 216 KB