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

From Tom Lane
Subject Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Date
Msg-id 15973.1490990130@sss.pgh.pa.us
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  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Mar 31, 2017 at 3:31 PM, Andres Freund <andres@anarazel.de> wrote:
>> Hm. Wonder if something like that shouldn't be backpatched - because
>> otherwise using postgres_fdw from an old server against a newer one will
>> do weird stuff.  I don't know what kind of policy we've committed to
>> with postgresImportForeignSchema...

> I don't think I'd like to promise that postgres_fdw will always be
> forward-compatible.  Backward-compatibility is hard enough already.

Unless I'm missing something, the behavior will be that an older
version will simply ignore remote partitioned tables (they will not
pass the relkind filter in the query).  Seems pretty fail-soft,
so I think it's fine.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Allow to specify #columns in heap/index_form_tuple
Next
From: Peter Geoghegan
Date:
Subject: Re: Allow to specify #columns in heap/index_form_tuple