Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx) - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)
Date
Msg-id 20091102165559.C6C7.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.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




pgsql-hackers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Re: Patch for automated partitioning
Next
From: Peter Eisentraut
Date:
Subject: Re: operator exclusion constraints