Re: postgres_fdw IMPORT SCHEMA and partitioned tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Date: 2017-03-31 19:55:30
Message-ID: 15973.1490990130@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Fri, Mar 31, 2017 at 3:31 PM, Andres Freund <andres(at)anarazel(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2017-03-31 20:08:21 Re: Allow to specify #columns in heap/index_form_tuple
Previous Message Peter Geoghegan 2017-03-31 19:43:42 Re: Allow to specify #columns in heap/index_form_tuple