Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> > Should we have "INHERITS ( parent INCLUDING xxx )" syntax ?
>
> No. That would imply that the user has some control over what is
> inherited and what isn't, which would be a complete mess.

Hmmm, but users can already control using LIKE INCLUDING clause what is
inherited and what isn't. Also, we don't inherit anything from INHERITS
clause in default. We have nothing to lose even if we support INHERITS
+ INCLUDING, no? And there are certain merits; we can avoid unexpected
log messages and don't have to repeat the parent name in DDL.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center