Re: inherit support for foreign tables - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: inherit support for foreign tables
Date
Msg-id 20140131180508.GM2921@tamriel.snowman.net
Whole thread Raw
In response to Re: inherit support for foreign tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > I agree that using the FDW-specific options is the right approach and
> > disallowing those to be set on foreign tables makes sense.  I don't
> > particularly like the idea of applying changes during inheiritance
> > which we wouldn't allow the user to do directly.  While it might be a
> > no-op and no FDW might use it, it'd still be confusing.
>
> If we don't allow it directly, why not?  Seems rather arbitrary.

I'm apparently missing something here.  From my perspective, they're
either allowed or they're not and if they aren't allowed then they
shouldn't be allowed to happen.  I'd view this like a CHECK constraint-
if it's a foreign table then it can't have a value for SET STORAGE.  I
don't see why it would be 'ok' to allow it to be set if we're setting it
as part of inheiritance but otherwise not allow it to be set.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: install libpq.dll in bin directory on Windows / Cygwin
Next
From: Andres Freund
Date:
Subject: Re: pgindent wishlist item