Re: inherit support for foreign tables

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: noah(at)leadboat(dot)com, shigeru(dot)hanada(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: inherit support for foreign tables
Date: 2014-10-14 11:00:49
Message-ID: 543D0261.6020803@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

(2014/09/12 16:30), Etsuro Fujita wrote:
> (2014/09/11 20:51), Heikki Linnakangas wrote:
>> On 09/11/2014 02:30 PM, Etsuro Fujita wrote:
>>> So, should I split the patch into the two?
>>
>> Yeah, please do.
>
> OK, Will do.

Here are separated patches.

fdw-chk.patch - CHECK constraints on foreign tables
fdw-inh.patch - table inheritance with foreign tables

The latter has been created on top of [1]. I've addressed the comment
from Horiguchi-san [2] in it also, though I've slightly modified his
proposal.

There is the functionality for path reparameterization for ForeignScan
in the previous patch, but since the functionality would be useful not
only for such table inheritance cases but for UNION ALL cases, I'd add
the functionality as an independent feature maybe to CF 2014-12.

Thanks,

[1] http://www.postgresql.org/message-id/540DA168.3040407@lab.ntt.co.jp
[2]
http://www.postgresql.org/message-id/20140902.142218.253402812.horiguchi.kyotaro@lab.ntt.co.jp

Best regards,
Etsuro Fujita

Attachment Content-Type Size
fdw-chk.patch text/x-diff 25.0 KB
fdw-inh.patch text/x-diff 78.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2014-10-14 12:35:00 Re: pgaudit - an auditing extension for PostgreSQL
Previous Message Andres Freund 2014-10-14 10:02:10 Re: Scaling shared buffer eviction