Re: Foreign Tables as Partitions

On Thu, Jul 18, 2013 at 8:56 PM, David Fetter <david(at)fetter(dot)org> wrote:
> Please find attached a PoC patch to implement $subject.
>
> So far, with a lot of help from Andrew Gierth, I've roughed out an
> implementation which allows you to ALTER FOREIGN TABLE so it inherits
> a local table.
>
> TBD: CREATE FOREIGN TABLE ... INHERITS ..., docs, regression testing,
> etc., etc.

I think this could be useful, but it's going to take more than a
three-line patch. Removing code that prohibits things is easy; what's
hard is verifying that nothing else breaks as a result. And I bet it
does.

This functionality was actually present in the original submission for
foreign tables. I ripped it out before commit because I didn't think
all of the interactions with other commands had been adequately
considered. But I think they did consider it to some degree, which
this patch does not.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company