Re: inherit support for foreign tables

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: shigeru(dot)hanada(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: inherit support for foreign tables
Date: 2014-03-31 10:06:16
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I've found some bugs. Attached is an updated version (v10).


* When CREATE FOREIGN TABLE INHERITS, don't allow a foreign table to
inherit from parent tables that have OID system columns.

* When CREATE FOREIGN TABLE INHERITS, reset the storage parameter for
inherited columns that have non-defaut values.

* Don't allow CHECK (expr) *NO INHERIT* on foreign tables, since those
tables cannot have child tables.

* Fix and update the documentation.


Best regards,
Etsuro Fujita

Attachment Content-Type Size
foreign_inherit-v10.patch text/plain 61.9 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-03-31 10:10:01 _mdfd_getseg can be expensive
Previous Message Andres Freund 2014-03-31 09:38:41 Re: MultiXactId error after upgrade to 9.3.4